ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D471D951A9E05362FB09050512 SELECT RCT.TRANSACTION_ID TX_ID ,HRU.NAME ORG ,PLC1.DISPLAYED_FIELD SRC_TYPE ,POV.VENDOR_NAME SRC ,DECODE(POL.purchase_basis, 'TEMP LABOR',POL.contractor_first_name || ' ' || POL.contractor_last_name, null) C_FLEX_ITEM ,null C_FLEX_CAT ,RSL.ITEM_REVISION REV ,RSL.ITEM_DESCRIPTION DES ,RSH.RECEIPT_NUM RECEIPT_NUM ,POH.SEGMENT1 || DECODE (POR.RELEASE_NUM,NULL,NULL,'-' || POR.RELEASE_NUM) || DECODE (POL.LINE_NUM,NULL,NULL,'-' || POL.LINE_NUM) || DECODE (PLL.SHIPMENT_NUM,NULL,NULL,'-'|| PLL.SHIPMENT_NUM) DOC_NUM ,TO_CHAR(RCT.TRANSACTION_DATE,'DD/MON/YYYY HH24:MI:SS') TX_DATE ,PLC2.DISPLAYED_FIELD TX_TYPE ,DECODE(POL.matching_basis, 'AMOUNT',RCT.currency_code, RCT.UNIT_OF_MEASURE) UOM ,DECODE(POL.matching_basis, 'AMOUNT',NULL, PLL.UNIT_MEAS_LOOKUP_CODE) PO_UOM ,round(DECODE(POL.matching_basis, 'AMOUNT',RCT.amount, RCT.QUANTITY), :P_qty_precision) QTY ,RCT.PO_UNIT_PRICE PRICE ,PDT.TYPE_NAME DOC_TYPE ,P2.FULL_NAME BUYER_PREPARER ,P1.FULL_NAME RECEIVER ,RSH.PACKING_SLIP PCKING_SLIP ,RCT.CREATION_DATE CREATION_DATE ,RCT.INSPECTION_QUALITY_CODE Q_CODE ,DECODE(RCT.RECEIPT_EXCEPTION_FLAG,'Y',:yes,'N',:no,null) EXCEPTION ,PLC3.DISPLAYED_FIELD PAR_TX_TYPE ,PLC.DISPLAYED_FIELD DESTINATION_TYPE ,P3.FULL_NAME DELIVER_TO_PERSON ,LOT.LOCATION_CODE DELIVER_TO_LOCATION ,RCT.SUBINVENTORY DESTINATION_SUBINVENTORY ,null C_FLEX_LOCATOR ,MTR.REASON_NAME TX_REASON ,RSL.ITEM_ID LS_ITEM_ID ,RCT.TRANSACTION_ID LS_TRANSACTION_ID ,RCT.SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID ,RCT.ORGANIZATION_ID LS_ORGANIZATION_ID ,WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, nvl2(RSL.ITEM_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp','INV','MSTK',101,MSI.ORGANIZATION_ID,MSI.INVENTORY_ITEM_ID,'ALL','Y','VALUE'),null) C_flex_item_disp, nvl2(RSL.CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp','INV','MCAT',MCA.STRUCTURE_ID,NULL,MCA.CATEGORY_ID,'ALL','Y','VALUE'),null) C_flex_cat_disp, nvl2(RCT.locator_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_locator_disp','INV','MTLL',101,MSL.ORGANIZATION_ID,MSL.INVENTORY_LOCATION_ID,'ALL','Y','VALUE'),null) C_FLEX_LOCATOR_DISP, PO_RCVTXRTR_new_XMLP_PKG.rcv_uom_convertformula(DECODE (POL.matching_basis,'AMOUNT',NULL,PLL.UNIT_MEAS_LOOKUP_CODE),DECODE (POL.matching_basis,'AMOUNT',RCT.currency_code,RCT.UNIT_OF_MEASURE),RSL.ITEM_ID,RCT.PO_UNIT_PRICE) RCV_UOM_CONVERT FROM PO_LOOKUP_CODES PLC, PO_LOOKUP_CODES PLC1, PO_LOOKUP_CODES PLC2, PO_LOOKUP_CODES PLC3, PO_RELEASES_ALL POR, PO_DOCUMENT_TYPES PDT, PO_DISTRIBUTIONS_ALL POD, PER_PEOPLE_F P2, PER_PEOPLE_F P3, HR_LOCATIONS_ALL_TL LOT, MTL_TRANSACTION_REASONS MTR, PO_VENDORS POV, HR_ORGANIZATION_UNITS HRU, MTL_SYSTEM_ITEMS MSI, MTL_CATEGORIES MCA, MTL_ITEM_LOCATIONS MSL, PO_HEADERS POH, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL, RCV_TRANSACTIONS PAR, RCV_SHIPMENT_LINES RSL, RCV_SHIPMENT_HEADERS RSH, PER_PEOPLE_F P1, RCV_TRANSACTIONS RCT, WMS_LICENSE_PLATE_NUMBERS WLPN1 WHERE MSI.INVENTORY_ITEM_ID (+)=RSL.ITEM_ID AND nvl(MSI.ORGANIZATION_ID,:organization_id)=:organization_id AND MCA.CATEGORY_ID=RSL.CATEGORY_ID AND MSL.INVENTORY_LOCATION_ID (+)=RCT.LOCATOR_ID AND nvl(MSL.ORGANIZATION_ID,RCT.ORGANIZATION_ID)=RCT.ORGANIZATION_ID AND RCT.SOURCE_DOCUMENT_CODE='PO' AND RSH.RECEIPT_SOURCE_CODE || ''='VENDOR' AND RCT.SHIPMENT_LINE_ID=RSL.SHIPMENT_LINE_ID AND RCT.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID AND RCT.PO_HEADER_ID=POH.PO_HEADER_ID AND RCT.PO_LINE_ID=POL.PO_LINE_ID AND RCT.PO_LINE_LOCATION_ID=PLL.LINE_LOCATION_ID AND RCT.PO_DISTRIBUTION_ID=POD.PO_DISTRIBUTION_ID (+) AND RCT.PO_RELEASE_ID=POR.PO_RELEASE_ID (+) AND ((POH.TYPE_LOOKUP_CODE='STANDARD' AND PDT.DOCUMENT_TYPE_CODE='PO' AND PDT.DOCUMENT_SUBTYPE='STANDARD') OR (PDT.DOCUMENT_TYPE_CODE='RELEASE' AND PDT.DOCUMENT_SUBTYPE=NVL(POR.RELEASE_TYPE,'~'))) AND (RCT.EMPLOYEE_ID=P1.PERSON_ID (+) AND trunc(RCT.CREATION_DATE) BETWEEN NVL(P1.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P1.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND (POH.AGENT_ID=P2.PERSON_ID (+) AND trunc(POH.APPROVED_DATE) BETWEEN NVL(P2.EFFECTIVE_START_DATE,trunc(POH.APPROVED_DATE)) AND NVL(P2.EFFECTIVE_END_DATE,trunc(POH.APPROVED_DATE))) AND PLC1.LOOKUP_CODE=RSH.RECEIPT_SOURCE_CODE || '' AND PLC1.LOOKUP_TYPE='SHIPMENT SOURCE TYPE' AND RSH.VENDOR_ID=POV.VENDOR_ID AND PAR.TRANSACTION_ID (+)=RCT.PARENT_TRANSACTION_ID AND LOT.LOCATION_ID(+)=RCT.DELIVER_TO_LOCATION_ID AND LOT.LANGUAGE(+)=USERENV('LANG') AND (P3.PERSON_ID(+)=RCT.DELIVER_TO_PERSON_ID and trunc(RCT.CREATION_DATE) BETWEEN NVL(P3.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P3.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND PLC.LOOKUP_CODE=RCT.DESTINATION_TYPE_CODE AND PLC.LOOKUP_TYPE='RCV DESTINATION TYPE' AND PLC2.LOOKUP_TYPE='RCV TRANSACTION TYPE' AND PLC2.LOOKUP_CODE=RCT.TRANSACTION_TYPE AND PLC3.LOOKUP_TYPE (+)='RCV TRANSACTION TYPE' AND PLC3.LOOKUP_CODE (+)=PAR.TRANSACTION_TYPE AND HRU.ORGANIZATION_ID=RCT.ORGANIZATION_ID AND &P_WHERE_ORG_ID AND MTR.REASON_ID(+)=RCT.REASON_ID AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND &P_WHERE_SHIP_NUM_FROM AND &P_WHERE_SHIP_NUM_TO AND &P_WHERE_ITEM AND &P_WHERE_CAT AND &P_WHERE_PO_NUM_FROM AND &P_WHERE_PO_NUM_TO AND &P_WHERE_TRX_DATE_FROM AND &P_WHERE_TRX_DATE_TO AND &P_WHERE_TRX_TYPE AND nvl(P1.FULL_NAME,'~')=nvl(:P_receiver,nvl(P1.FULL_NAME,'~')) AND &P_WHERE_BUYER AND &P_WHERE_VENDOR_FROM AND &P_WHERE_VENDOR_TO AND ((:P_req_num_from is null and :P_req_num_to is null and :P_rma_num_from is null and :P_rma_num_to is null and :P_customer_from is null and :P_customer_to is null) OR(:P_vendor_from is not null or :P_vendor_to is not null or :P_po_num_from is not null or :P_po_num_to is not null)) AND (:P_exception is null or (:P_exception is not null and rct.receipt_exception_flag=:P_exception)) AND RCT.TRANSFER_LPN_ID=WLPN1.LPN_ID(+) UNION SELECT RCT.TRANSACTION_ID TX_ID ,HRU.NAME ORG ,PLC1.DISPLAYED_FIELD SRC_TYPE ,HRU1.NAME || PRL.SOURCE_SUBINVENTORY SRC ,null C_FLEX_ITEM ,null C_FLEX_CAT ,RSL.ITEM_REVISION REV ,RSL.ITEM_DESCRIPTION DES ,RSH.RECEIPT_NUM RECEIPT_NUM ,PRH.SEGMENT1 DOC_NUM ,TO_CHAR(RCT.TRANSACTION_DATE,'DD/MON/YYYY HH24:MI:SS') TX_DATE ,PLC2.DISPLAYED_FIELD TX_TYPE ,RCT.UNIT_OF_MEASURE UOM ,NULL PO_UOM ,round(RCT.QUANTITY,:P_qty_precision) QTY ,PRL.UNIT_PRICE PRICE ,PDT.TYPE_NAME DOC_TYPE ,P2.FULL_NAME BUYER_PREPARER ,P1.FULL_NAME RECEIVER ,RSH.PACKING_SLIP PCKING_SLIP ,RCT.CREATION_DATE CREATION_DATE ,RCT.INSPECTION_QUALITY_CODE Q_CODE ,DECODE(RCT.RECEIPT_EXCEPTION_FLAG,'Y',:yes,'N',:no,null) EXCEPTION ,PLC3.DISPLAYED_FIELD PAR_TX_TYPE ,PLC.DISPLAYED_FIELD DESTINATION_TYPE ,P3.FULL_NAME DELIVER_TO_PERSON ,LOT.LOCATION_CODE DELIVER_TO_LOCATION ,RCT.SUBINVENTORY DESTINATION_SUBINVENTORY ,null C_FLEX_LOCATOR ,MTR.REASON_NAME TX_REASON ,RSL.ITEM_ID LS_ITEM_ID ,RCT.TRANSACTION_ID LS_TRANSACTION_ID ,RCT.SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID ,RCT.ORGANIZATION_ID LS_ORGANIZATION_ID ,WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, nvl2(RSL.ITEM_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp','INV','MSTK',101,MSI.ORGANIZATION_ID,MSI.INVENTORY_ITEM_ID,'ALL','Y','VALUE'),null) C_flex_item_disp, nvl2(RSL.CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp','INV','MCAT',MCA.STRUCTURE_ID,NULL,MCA.CATEGORY_ID,'ALL','Y','VALUE'),null) C_flex_cat_disp, nvl2(RCT.locator_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_locator_disp','INV','MTLL',101,MSL.ORGANIZATION_ID,MSL.INVENTORY_LOCATION_ID,'ALL','Y','VALUE'),null) C_FLEX_LOCATOR_DISP, PO_RCVTXRTR_new_XMLP_PKG.rcv_uom_convertformula(NULL,RCT.UNIT_OF_MEASURE,RSL.ITEM_ID,PRL.UNIT_PRICE) RCV_UOM_CONVERT FROM PO_LOOKUP_CODES PLC, PO_LOOKUP_CODES PLC1, PO_LOOKUP_CODES PLC2, PO_LOOKUP_CODES PLC3, PO_DOCUMENT_TYPES PDT, PER_PEOPLE_F P2, PER_PEOPLE_F P3, MTL_TRANSACTION_REASONS MTR, HR_ORGANIZATION_UNITS HRU, HR_LOCATIONS_ALL_TL LOT, HR_ORGANIZATION_UNITS HRU1, MTL_SYSTEM_ITEMS MSI, MTL_CATEGORIES MCA, MTL_ITEM_LOCATIONS MSL, PO_REQUISITION_HEADERS PRH, PO_REQUISITION_LINES_ALL PRL, RCV_TRANSACTIONS PAR, RCV_SHIPMENT_LINES RSL, RCV_SHIPMENT_HEADERS RSH, PER_PEOPLE_F P1, RCV_TRANSACTIONS RCT, WMS_LICENSE_PLATE_NUMBERS WLPN1 WHERE MSI.INVENTORY_ITEM_ID (+)=RSL.ITEM_ID AND nvl(MSI.ORGANIZATION_ID,:organization_id)=:organization_id AND MCA.CATEGORY_ID=RSL.CATEGORY_ID AND MSL.INVENTORY_LOCATION_ID (+)=RCT.LOCATOR_ID AND nvl(MSL.ORGANIZATION_ID,RCT.ORGANIZATION_ID)=RCT.ORGANIZATION_ID AND RCT.SHIPMENT_LINE_ID=RSL.SHIPMENT_LINE_ID AND RCT.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID AND RCT.REQUISITION_LINE_ID=PRL.REQUISITION_LINE_ID AND PRL.REQUISITION_HEADER_ID=PRH.REQUISITION_HEADER_ID AND RSH.ORGANIZATION_ID=HRU1.ORGANIZATION_ID AND PDT.DOCUMENT_SUBTYPE=PRH.TYPE_LOOKUP_CODE AND PDT.DOCUMENT_TYPE_CODE='REQUISITION' AND RCT.SOURCE_DOCUMENT_CODE='REQ' AND RSH.RECEIPT_SOURCE_CODE || ''='INTERNAL ORDER' AND (RCT.EMPLOYEE_ID=P1.PERSON_ID (+) AND trunc(RCT.CREATION_DATE) BETWEEN NVL(P1.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P1.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND (PRH.PREPARER_ID=P2.PERSON_ID AND trunc(PRH.LAST_UPDATE_DATE) BETWEEN NVL(P2.EFFECTIVE_START_DATE,trunc(PRH.LAST_UPDATE_DATE)) AND NVL(P2.EFFECTIVE_END_DATE,trunc(PRH.LAST_UPDATE_DATE))) AND PLC1.LOOKUP_CODE=RSH.RECEIPT_SOURCE_CODE || '' AND PLC1.LOOKUP_TYPE='SHIPMENT SOURCE TYPE' AND PAR.TRANSACTION_ID (+)=RCT.PARENT_TRANSACTION_ID AND PLC.LOOKUP_CODE=PRL.DESTINATION_TYPE_CODE AND PLC.LOOKUP_TYPE='RCV DESTINATION TYPE' AND (P3.PERSON_ID=PRL.TO_PERSON_ID AND trunc(PRL.LAST_UPDATE_DATE) BETWEEN NVL(P3.EFFECTIVE_START_DATE,trunc(PRL.LAST_UPDATE_DATE)) AND NVL(P3.EFFECTIVE_END_DATE,trunc(PRL.LAST_UPDATE_DATE))) AND LOT.LOCATION_ID(+)=PRL.DELIVER_TO_LOCATION_ID AND LOT.LANGUAGE(+)=USERENV('LANG') AND PLC2.LOOKUP_TYPE='RCV TRANSACTION TYPE' AND PLC2.LOOKUP_CODE=RCT.TRANSACTION_TYPE AND PLC3.LOOKUP_TYPE (+)='RCV TRANSACTION TYPE' AND PLC3.LOOKUP_CODE (+)=PAR.TRANSACTION_TYPE AND HRU.ORGANIZATION_ID=RCT.ORGANIZATION_ID AND &P_WHERE_ORG_ID AND MTR.REASON_ID(+)=RCT.REASON_ID AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND &P_WHERE_SHIP_NUM_FROM AND &P_WHERE_SHIP_NUM_TO AND &P_WHERE_ITEM AND &P_WHERE_CAT AND &P_WHERE_REQ_NUM_FROM AND &P_WHERE_REQ_NUM_TO AND &P_WHERE_TRX_DATE_FROM AND &P_WHERE_TRX_DATE_TO AND &P_WHERE_TRX_TYPE AND nvl(P1.FULL_NAME,'~')=nvl(:P_receiver,nvl(P1.FULL_NAME,'~')) AND &P_WHERE_BUYER AND ((:P_po_num_from is null and :P_po_num_to is null and :P_vendor_from is null and :P_vendor_to is null and :P_rma_num_from is null and :P_rma_num_to is null and :P_customer_from is null and :P_customer_to is null) OR(:P_req_num_from is not null or :P_req_num_to is not null)) AND (:P_exception is null or (:P_exception is not null and rct.receipt_exception_flag=:P_exception)) AND RCT.TRANSFER_LPN_ID=WLPN1.LPN_ID(+) UNION SELECT RCT.TRANSACTION_ID TX_ID ,HRU.NAME ORG ,PLC1.DISPLAYED_FIELD SRC_TYPE ,HRU1.NAME SRC ,null C_FLEX_ITEM ,null C_FLEX_CAT ,RSL.ITEM_REVISION REV ,RSL.ITEM_DESCRIPTION DES ,RSH.RECEIPT_NUM RECEIPT_NUM ,RSH.SHIPMENT_NUM DOC_NUM ,TO_CHAR(RCT.TRANSACTION_DATE,'DD/MON/YYYY HH24:MI:SS') TX_DATE ,PLC2.DISPLAYED_FIELD TX_TYPE ,RCT.UNIT_OF_MEASURE UOM ,NULL PO_UOM ,round(RCT.QUANTITY,:P_qty_precision) QTY ,RSL.SHIPMENT_UNIT_PRICE PRICE ,PLC4.DISPLAYED_FIELD DOC_TYPE ,'' BUYER_PREPARER ,P.FULL_NAME RECEIVER ,RSH.PACKING_SLIP PCKING_SLIP ,RCT.CREATION_DATE CREATION_DATE ,RCT.INSPECTION_QUALITY_CODE Q_CODE ,DECODE(RCT.RECEIPT_EXCEPTION_FLAG,'Y',:yes,'N',:no,null) EXCEPTION ,PLC3.DISPLAYED_FIELD PAR_TX_TYPE ,PLC.DISPLAYED_FIELD DESTINATION_TYPE ,P1.FULL_NAME DELIVER_TO_PERSON ,LOT.LOCATION_CODE DELIVER_TO_LOCATION ,RCT.SUBINVENTORY DESTINATION_SUBINVENTORY ,null C_FLEX_LOCATOR ,MTR.REASON_NAME TX_REASON ,RSL.ITEM_ID LS_ITEM_ID ,RCT.TRANSACTION_ID LS_TRANSACTION_ID ,RCT.SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID ,RCT.ORGANIZATION_ID LS_ORGANIZATION_ID ,WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, nvl2(RSL.ITEM_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp','INV','MSTK',101,MSI.ORGANIZATION_ID,MSI.INVENTORY_ITEM_ID,'ALL','Y','VALUE'),null) C_flex_item_disp, nvl2(RSL.CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp','INV','MCAT',MCA.STRUCTURE_ID,NULL,MCA.CATEGORY_ID,'ALL','Y','VALUE'),null) C_flex_cat_disp, nvl2(RCT.locator_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_locator_disp','INV','MTLL',101,MSL.ORGANIZATION_ID,MSL.INVENTORY_LOCATION_ID,'ALL','Y','VALUE'),null) C_FLEX_LOCATOR_DISP, PO_RCVTXRTR_new_XMLP_PKG.rcv_uom_convertformula(NULL,RCT.UNIT_OF_MEASURE,RSL.ITEM_ID,RSL.SHIPMENT_UNIT_PRICE) RCV_UOM_CONVERT FROM PO_LOOKUP_CODES PLC ,PO_LOOKUP_CODES PLC1 ,PO_LOOKUP_CODES PLC2 ,PO_LOOKUP_CODES PLC3 ,PO_LOOKUP_CODES PLC4 ,PER_PEOPLE_F P1 ,HR_ORGANIZATION_UNITS HRU1 ,HR_LOCATIONS_ALL_TL LOT ,MTL_TRANSACTION_REASONS MTR ,HR_ORGANIZATION_UNITS HRU ,MTL_SYSTEM_ITEMS MSI ,MTL_CATEGORIES MCA ,MTL_ITEM_LOCATIONS MSL ,RCV_TRANSACTIONS PAR ,RCV_SHIPMENT_LINES RSL ,RCV_SHIPMENT_HEADERS RSH ,PER_PEOPLE_F P ,RCV_TRANSACTIONS RCT ,WMS_LICENSE_PLATE_NUMBERS WLPN1 WHERE MSI.INVENTORY_ITEM_ID (+)=RSL.ITEM_ID AND nvl(MSI.ORGANIZATION_ID,:organization_id)=:organization_id AND MCA.CATEGORY_ID=RSL.CATEGORY_ID AND MSL.INVENTORY_LOCATION_ID (+)=RCT.LOCATOR_ID AND nvl(MSL.ORGANIZATION_ID,RCT.ORGANIZATION_ID)=RCT.ORGANIZATION_ID AND RCT.SHIPMENT_LINE_ID=RSL.SHIPMENT_LINE_ID AND RCT.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID AND RSH.RECEIPT_SOURCE_CODE || ''='INVENTORY' AND PLC4.LOOKUP_CODE=RCT.SOURCE_DOCUMENT_CODE AND PLC4.LOOKUP_TYPE='SHIPMENT SOURCE DOCUMENT TYPE' AND PLC1.LOOKUP_CODE=RSH.RECEIPT_SOURCE_CODE || '' AND PLC1.LOOKUP_TYPE='SHIPMENT SOURCE TYPE' AND (RCT.EMPLOYEE_ID=P.person_id (+) AND trunc(RCT.CREATION_DATE) BETWEEN NVL(P.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND RSH.ORGANIZATION_ID=HRU1.ORGANIZATION_ID AND PAR.TRANSACTION_ID (+)=RCT.PARENT_TRANSACTION_ID AND LOT.LOCATION_ID(+)=RCT.DELIVER_TO_LOCATION_ID AND LOT.LANGUAGE(+)=USERENV('LANG') AND (P1.person_id(+)=RCT.DELIVER_TO_PERSON_ID AND trunc(RCT.CREATION_DATE) BETWEEN NVL(P1.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P1.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND PLC.LOOKUP_CODE=RSL.DESTINATION_TYPE_CODE AND PLC.LOOKUP_TYPE='RCV DESTINATION TYPE' AND PLC2.LOOKUP_TYPE='RCV TRANSACTION TYPE' AND PLC2.LOOKUP_CODE=RCT.TRANSACTION_TYPE AND PLC3.LOOKUP_TYPE (+)='RCV TRANSACTION TYPE' AND PLC3.LOOKUP_CODE (+)=PAR.TRANSACTION_TYPE AND HRU.ORGANIZATION_ID=RCT.ORGANIZATION_ID AND &P_WHERE_ORG_ID AND MTR.REASON_ID(+)=RCT.REASON_ID AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND &P_WHERE_SHIP_NUM_FROM AND &P_WHERE_SHIP_NUM_TO AND &P_WHERE_ITEM AND &P_WHERE_CAT AND &P_WHERE_TRX_DATE_FROM AND &P_WHERE_TRX_DATE_TO AND &P_WHERE_TRX_TYPE AND nvl(P.FULL_NAME,'~')=nvl(:P_receiver,nvl(P.FULL_NAME,'~')) AND :P_buyer is NULL AND &P_WHERE_SHIP_NUM_FROM AND &P_WHERE_SHIP_NUM_TO AND ((:P_po_num_from is null and :P_po_num_to is null and :P_req_num_from is null and :P_req_num_to is null and :P_vendor_from is null and :P_vendor_to is null and :P_rma_num_from is null and :P_rma_num_to is null and :P_customer_from is null and :P_customer_to is null) OR(:P_ship_num_from is not null or :P_ship_num_to is not null)) and nvl(p.business_group_id,0)=(select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) and trunc(sysdate) between nvl(p.effective_start_date,trunc(sysdate)) and nvl(p.effective_end_date,trunc(sysdate)) and ((nvl(p1.business_group_id,0)=(select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)) or NVL(rct.deliver_to_person_id,0)=0) and trunc(sysdate) between nvl(p1.effective_start_date,trunc(sysdate)) and nvl(p1.effective_end_date,trunc(sysdate)) AND (:P_exception is null or (:P_exception is not null and rct.receipt_exception_flag=:P_exception)) AND RCT.TRANSFER_LPN_ID=WLPN1.LPN_ID(+) UNION SELECT rct.transaction_id tx_id, hru.NAME org, plc1.displayed_field src_type, DECODE(rct.source_document_code, 'PO',pov.vendor_name, oev.NAME ) src, null c_flex_item, null c_flex_cat, rsl.item_revision rev, rsl.item_description des, rsh.receipt_num receipt_num, '' doc_num, TO_CHAR(rct.transaction_date,'DD/MON/YYYY HH24:MI:SS') tx_date, plc2.displayed_field tx_type, rct.unit_of_measure uom, NULL po_uom, ROUND(rct.quantity,:p_qty_precision) qty, TO_NUMBER('') price, '' doc_type, '' buyer_preparer, p.full_name receiver, rsh.packing_slip pcking_slip, rct.creation_date creation_date, rct.inspection_quality_code q_code, DECODE(rct.receipt_exception_flag, 'Y',:yes, 'N',:NO, NULL ) EXCEPTION, plc3.displayed_field par_tx_type, plc.displayed_field destination_type, p2.full_name deliver_to_person, lot.location_code deliver_to_location, '' destination_subinventory, null c_flex_locator, mtr.reason_name tx_reason, rsl.item_id ls_item_id, rct.transaction_id ls_transaction_id, rct.shipment_line_id ls_shipment_line_id, rct.organization_id ls_organization_id, wlpn1.license_plate_number license_plate_number, nvl2(RSL.ITEM_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp','INV','MSTK',101,MSI.ORGANIZATION_ID,MSI.INVENTORY_ITEM_ID,'ALL','Y','VALUE'),null) C_flex_item_disp, nvl2(RSL.CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp','INV','MCAT',MCA.STRUCTURE_ID,NULL,MCA.CATEGORY_ID,'ALL','Y','VALUE'),null) C_flex_cat_disp, nvl2(rct.locator_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_locator_disp','INV','MTLL',101,MSL.ORGANIZATION_ID,MSL.INVENTORY_LOCATION_ID,'ALL','Y','VALUE'),null) C_FLEX_LOCATOR_DISP, PO_RCVTXRTR_new_XMLP_PKG.rcv_uom_convertformula(NULL,rct.unit_of_measure,rsl.item_id,TO_NUMBER('')) RCV_UOM_CONVERT FROM po_lookup_codes plc, po_lookup_codes plc1, po_lookup_codes plc2, po_lookup_codes plc3, per_people_f p2, hr_locations_all_tl lot, mtl_transaction_reasons mtr, po_vendors pov, hr_organization_units hru, mtl_system_items msi, mtl_categories mca, mtl_item_locations msl, rcv_transactions par, rcv_shipment_lines rsl, rcv_shipment_headers rsh, per_people_f p, rcv_transactions rct, wms_license_plate_numbers wlpn1, oe_sold_to_orgs_v oev WHERE msi.inventory_item_id(+)=rsl.item_id AND msi.organization_id(+)=:organization_id AND mca.category_id=rsl.category_id AND msl.inventory_location_id(+)=rct.locator_id AND msl.organization_id(+)=rct.organization_id AND rct.source_document_code IN('PO','RMA') AND rsh.receipt_source_code IN('VENDOR','CUSTOMER') AND rct.shipment_line_id=rsl.shipment_line_id AND rct.shipment_header_id=rsh.shipment_header_id AND (rct.employee_id=p.person_id(+) AND TRUNC(rct.creation_date) BETWEEN NVL(p.effective_start_date,TRUNC(rct.creation_date)) AND NVL(p.effective_end_date,TRUNC(rct.creation_date))) AND plc1.lookup_code=rsh.receipt_source_code AND plc1.lookup_type='SHIPMENT SOURCE TYPE' AND rsh.vendor_id=pov.vendor_id(+) AND par.transaction_id(+)=rct.parent_transaction_id AND lot.location_id(+)=rct.deliver_to_location_id AND lot.LANGUAGE(+)=USERENV('LANG') AND (p2.person_id(+)=rct.deliver_to_person_id AND TRUNC(rct.creation_date) BETWEEN NVL(p2.effective_start_date,TRUNC(rct.creation_date)) AND NVL(p2.effective_end_date,TRUNC(rct.creation_date))) AND plc.lookup_code=rct.destination_type_code AND plc.lookup_type='RCV DESTINATION TYPE' AND plc2.lookup_type='RCV TRANSACTION TYPE' AND plc2.lookup_code=rct.transaction_type AND plc3.lookup_type(+)='RCV TRANSACTION TYPE' AND plc3.lookup_code(+)=par.transaction_type AND hru.organization_id=rct.organization_id AND &p_where_org_id AND mtr.reason_id(+)=rct.reason_id AND &p_where_receipt_num_from AND &p_where_receipt_num_to AND &p_where_ship_num_from AND &p_where_ship_num_to AND &p_where_item AND &p_where_cat AND &p_where_trx_date_from AND &p_where_trx_date_to AND &p_where_trx_type AND NVL(p.full_name,'~')=NVL(:p_receiver,NVL(p.full_name,'~')) AND :p_buyer IS NULL AND &p_where_vendor_from AND &p_where_vendor_to AND rct.transaction_type='UNORDERED' AND ((:p_req_num_from IS NULL AND :p_req_num_to IS NULL AND :p_po_num_from IS NULL AND :p_po_num_to IS NULL AND :p_rma_num_from IS NULL AND :p_rma_num_to IS NULL AND :p_customer_from IS NULL AND :p_customer_to IS NULL) OR (:p_vendor_from IS NOT NULL OR :p_vendor_to IS NOT NULL) ) AND NVL(p.business_group_id,0)=(SELECT NVL(MAX(fsp.business_group_id),0) FROM financials_system_parameters fsp) AND TRUNC(SYSDATE) BETWEEN NVL(p.effective_start_date,TRUNC(SYSDATE)) AND NVL(p.effective_end_date,TRUNC(SYSDATE)) AND ((NVL(p2.business_group_id,0)=(SELECT NVL(MAX(fsp.business_group_id),0) FROM financials_system_parameters fsp)) OR NVL(rct.deliver_to_person_id,0)=0) AND TRUNC(SYSDATE) BETWEEN NVL(p2.effective_start_date,TRUNC(SYSDATE)) AND NVL(p2.effective_end_date,TRUNC(SYSDATE)) AND (:p_exception IS NULL OR (:p_exception IS NOT NULL AND rct.receipt_exception_flag=:p_exception)) AND rct.transfer_lpn_id=wlpn1.lpn_id(+) AND oev.customer_id(+)=rsh.customer_id UNION SELECT rct.transaction_id TX_ID ,HRU.name ORG ,plc1.displayed_field SRC_TYPE ,oev.name src ,null C_FLEX_ITEM ,null C_FLEX_CAT ,rsl.item_revision REV ,rsl.item_description DES ,rsh.receipt_num receipt_num ,to_char(oeh.order_number) || '-' || to_char(oel.line_number) doc_num ,TO_CHAR(rct.transaction_date,'DD/MON/YYYY HH24:MI:SS') tx_date ,plc2.displayed_field tx_type ,RCT.UNIT_OF_MEASURE UOM ,NULL PO_UOM ,RCT.QUANTITY QTY ,rsl.shipment_unit_price PRICE ,'RMA' DOC_TYPE ,to_char(null) BUYER_PREPARER ,P1.FULL_NAME RECEIVER ,RSH.PACKING_SLIP PCKING_SLIP ,RCT.CREATION_DATE CREATION_DATE ,RCT.INSPECTION_QUALITY_CODE Q_CODE ,DECODE(RCT.RECEIPT_EXCEPTION_FLAG,'Y',:yes,'N',:no,null) EXCEPTION ,PLC3.DISPLAYED_FIELD PAR_TX_TYPE ,PLC.DISPLAYED_FIELD DESTINATION_TYPE ,P3.FULL_NAME DELIVER_TO_PERSON ,LOT.LOCATION_CODE DELIVER_TO_LOCATION ,RCT.SUBINVENTORY DESTINATION_SUBINVENTORY ,null C_FLEX_LOCATOR ,MTR.REASON_NAME TX_REASON ,RSL.ITEM_ID LS_ITEM_ID ,RCT.TRANSACTION_ID LS_TRANSACTION_ID ,RCT.SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID ,RCT.ORGANIZATION_ID LS_ORGANIZATION_ID ,WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, nvl2(RSL.ITEM_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp','INV','MSTK',101,MSI.ORGANIZATION_ID,MSI.INVENTORY_ITEM_ID,'ALL','Y','VALUE'),null) C_flex_item_disp, nvl2(RSL.CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp','INV','MCAT',MCA.STRUCTURE_ID,NULL,MCA.CATEGORY_ID,'ALL','Y','VALUE'),null) C_flex_cat_disp, nvl2(rct.locator_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_locator_disp','INV','MTLL',101,MSL.ORGANIZATION_ID,MSL.INVENTORY_LOCATION_ID,'ALL','Y','VALUE'),null) C_FLEX_LOCATOR_DISP, PO_RCVTXRTR_new_XMLP_PKG.rcv_uom_convertformula(NULL,RCT.UNIT_OF_MEASURE,RSL.ITEM_ID,rsl.shipment_unit_price) RCV_UOM_CONVERT FROM RCV_transactions rct ,RCV_transactions par ,hr_organization_units hru ,rcv_shipment_headers rsh ,po_lookup_codes plc1 ,po_lookup_codes plc2 ,oe_sold_to_orgs_v oev ,rcv_shipment_lines rsl ,MTL_SYSTEM_ITEMS MSI ,MTL_CATEGORIES MCA ,per_people_f p1 ,per_people_f p3 ,po_lookup_codes plc3 ,po_lookup_codes plc ,HR_LOCATIONS_ALL_TL LOT ,MTL_TRANSACTION_REASONS MTR ,MTL_ITEM_LOCATIONS MSL ,OE_ORDER_HEADERS OEH ,OE_ORDER_LINES OEL ,WMS_LICENSE_PLATE_NUMBERS WLPN1 where RCT.SOURCE_DOCUMENT_CODE='RMA' AND RSH.RECEIPT_SOURCE_CODE || ''='CUSTOMER' AND PAR.TRANSACTION_ID (+)=RCT.PARENT_TRANSACTION_ID AND hru.organization_id=rct.organization_id AND &P_WHERE_ORG_ID AND PLC1.LOOKUP_CODE=RSH.RECEIPT_SOURCE_CODE || '' AND PLC1.LOOKUP_TYPE='SHIPMENT SOURCE TYPE' AND PLC.LOOKUP_CODE=RCT.DESTINATION_TYPE_CODE AND PLC.LOOKUP_TYPE='RCV DESTINATION TYPE' AND oev.customer_id (+)=rsh.customer_id AND RCT.SHIPMENT_LINE_ID=RSL.SHIPMENT_LINE_ID AND RCT.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID AND RSH.shipment_header_id=rsl.shipment_header_id AND MCA.CATEGORY_ID (+)=RSL.CATEGORY_ID AND MSI.INVENTORY_ITEM_ID (+)=RSL.ITEM_ID AND MSL.INVENTORY_LOCATION_ID (+)=RCT.LOCATOR_ID AND nvl(MSL.ORGANIZATION_ID,RCT.ORGANIZATION_ID)=RCT.ORGANIZATION_ID AND PLC2.LOOKUP_TYPE='RCV TRANSACTION TYPE' AND PLC2.LOOKUP_CODE=RCT.TRANSACTION_TYPE AND (RCT.EMPLOYEE_ID=P1.PERSON_ID (+) AND trunc(RCT.CREATION_DATE) BETWEEN NVL(P1.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P1.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND PLC3.LOOKUP_TYPE (+)='RCV TRANSACTION TYPE' AND PLC3.LOOKUP_CODE (+)=PAR.TRANSACTION_TYPE AND (P3.PERSON_ID(+)=RCT.DELIVER_TO_PERSON_ID and trunc(RCT.CREATION_DATE) BETWEEN NVL(P3.EFFECTIVE_START_DATE,trunc(RCT.CREATION_DATE)) AND NVL(P3.EFFECTIVE_END_DATE,trunc(RCT.CREATION_DATE))) AND LOT.LOCATION_ID(+)=RCT.DELIVER_TO_LOCATION_ID AND LOT.LANGUAGE(+)=USERENV('LANG') AND MTR.REASON_ID(+)=RCT.REASON_ID AND OEH.header_id=rct.oe_order_header_id AND oel.line_id=rct.oe_order_line_id AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND &P_WHERE_SHIP_NUM_FROM AND &P_WHERE_SHIP_NUM_TO AND &P_WHERE_ITEM AND &P_WHERE_CAT AND &P_WHERE_RMA_NUM_FROM AND &P_WHERE_RMA_NUM_TO AND &P_WHERE_TRX_DATE_FROM AND &P_WHERE_TRX_DATE_TO AND &P_WHERE_TRX_TYPE AND &P_WHERE_CUSTOMER_FROM AND &P_WHERE_CUSTOMER_TO AND ((:P_req_num_from is null and :P_req_num_to is null and :P_po_num_from is null and :P_po_num_to is null and :P_vendor_from is null and :P_vendor_to is null) OR(:P_customer_from is not null or :P_customer_to is not null or :P_rma_num_from is not null or :P_rma_num_to is not null)) AND nvl(P1.FULL_NAME,'~')=nvl(:P_receiver,nvl(P1.FULL_NAME,'~')) AND :P_buyer is NULL AND RCT.TRANSFER_LPN_ID=WLPN1.LPN_ID(+) order by 3,4,5,36,37,9,10,11,35,14,2,19,1,33,31,7,8,38,12,34,13,15,16,32,17,18,20,21,22,23,24,25,26,27,28,30 Y PO RCVTXRTR_XML AR PO مسجل حركات الاستلام (بتنسيق XML) Imported from BI Publisher Description: مسجل حركات الاستلام Application: المشتريات Source: مسجل حركات الاستلام (بتنسيق XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG D PO Wareneingang - Transaktionen Imported from BI Publisher Description: Wareneingang - Transaktionen Application: Einkauf Source: Wareneingang - Transaktionen (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG E PO Registro de Transacciones de Recepción Imported from BI Publisher Description: Registro de Transacciones de Recepción Application: Purchasing Source: Registro de Transacciones de Recepción (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG F PO Registre des mouvements de réception Imported from BI Publisher Description: Registre des mouvements de réception Application: Purchasing Source: Registre des mouvements de réception (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG I PO Registro transazioni di ricezione Imported from BI Publisher Description: Registro transazioni di ricezione Application: Purchasing Source: Registro transazioni di ricezione (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG JA PO 受入取引台帳 Imported from BI Publisher Description: 受入取引台帳 Application: Purchasing Source: 受入取引台帳(XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG KO PO 입고 트랜잭션 등록 Imported from BI Publisher Description: 입고 트랜잭션 등록 Application: Purchasing Source: 입고 트랜잭션 등록(XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG PTB PO Registro de Transações de Recebimento Imported from BI Publisher Description: Registro de Transações de Recebimento Application: Compra Source: Registro de Transações de Recebimento (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG RU PO Реестр транзакций получения Imported from BI Publisher Description: Реестр транзакций получения Application: Закупки Source: Реестр транзакций получения (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG S PO Register över mottagningstransaktioner Imported from BI Publisher Description: Register över inleveranstransaktioner Application: Purchasing Source: Register över mottagningstransaktioner (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG TR PO Teslim Alma İşlemleri Kaydı Imported from BI Publisher Description: Teslim Alma İşlemleri Kaydı Application: Satın Alma Yönetimi Source: Teslim Alma İşlemleri Kaydı (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG US PO Receiving Transactions Register Imported from BI Publisher Description: Receiving Transactions Register Application: Purchasing Source: Receiving Transactions Register (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG ZHS PO 接收事务处理登记表 Imported from BI Publisher Description: 接收事务处理登记表 Application: 采购管理系统 Source: 接收事务处理登记表 (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG BI Publisher &p_where_buyer &p_where_cat &p_where_customer_from &p_where_customer_to &p_where_item &p_where_org_id &p_where_po_num_from &p_where_po_num_to &p_where_receipt_num_from &p_where_receipt_num_to &p_where_req_num_from &p_where_req_num_to &p_where_rma_num_from &p_where_rma_num_to &p_where_ship_num_from &p_where_ship_num_to &p_where_trx_date_from &p_where_trx_date_to &p_where_trx_type &p_where_vendor_from &p_where_vendor_to :item_id :no :operating_unit :organization_id :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_customer_from :p_customer_to :p_detail_summary :p_exception :p_flex_cat :p_flex_item :p_flex_locator :p_inc_lot_and_serial :p_inv_status :p_item_from :p_item_struct_num :p_item_to :p_org_displayed :p_org_id :p_po_num_from :p_po_num_to :p_qty_precision :p_receipt_num_from :p_receipt_num_to :p_receiver :p_req_num_from :p_req_num_to :p_rma_num_from :p_rma_num_to :p_ship_num_from :p_ship_num_to :p_sort_by :p_struct_num :p_struct_num1 :p_title :p_trx_date_from :p_trx_date_to :p_trx_type :p_vendor_from :p_vendor_to :p_where_buyer :p_where_cat :p_where_customer_from :p_where_customer_to :p_where_item :p_where_org_id :p_where_po_num_from :p_where_po_num_to :p_where_receipt_num_from :p_where_receipt_num_to :p_where_receiver :p_where_req_num_from :p_where_req_num_to :p_where_rma_num_from :p_where_rma_num_to :p_where_ship_num_from :p_where_ship_num_to :p_where_trx_date_from :p_where_trx_date_to :p_where_trx_type :p_where_vendor_from :p_where_vendor_to :rrp_from_interface :rrp_organization_id :rrp_shipment_line_id :rrp_transaction_id :yes 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR P_STRUCT_NUM رقم الهيكل D P_STRUCT_NUM Strukturnummer E P_STRUCT_NUM Número de Estructura F P_STRUCT_NUM Numéro de structure I P_STRUCT_NUM Numero struttura JA P_STRUCT_NUM 体系番号 KO P_STRUCT_NUM 구조번호 PTB P_STRUCT_NUM Número da estrutura RU P_STRUCT_NUM Номер структуры S P_STRUCT_NUM Strukturnummer TR P_STRUCT_NUM Yapı Numarası US P_STRUCT_NUM Structure number ZHS P_STRUCT_NUM 结构编号 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 4 20 :p_org_id LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description AR التنظيم معرف التنظيم D Organisation Organisationskennung E Organización Id Organización F Organisation ID organisation I Organizzazione Id organizzazione JA 組織 組織ID KO 조직 조직 ID PTB Organização Id da Organização RU Организация Идентификатор организации S Organisation Organisations-id TR Organizasyon Organizasyon No US Organization Organization Id ZHS 组织 组织标识 5 30 :p_trx_type LOV Oracle PO_SRS_TRANSACTION_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='RCV TRANSACTION TYPE' order by displayed_field AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de mouvement Type de mouvement I Tipo transazione Tipo transazione JA 取引タイプ 取引タイプ KO 트랜잭션 유형 트랜잭션 유형 PTB Tipo de Transação Tipo de Transação RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp TR İşlem Tipi İşlem Tipi US Transaction Type Transaction Type ZHS 事务处理类型 事务处理类型 6 40 :p_trx_date_from DateTime AR تواريخ الحركات من تواريخ الحركات من D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De Fecha de Transacción F Dates de mouvement - Du Dates de mouvement - Du I Date transazione - Da Date transazione - Da JA 取引日:自 取引日:自 KO 트랜잭션 일자: 부터 트랜잭션 일자: 부터 PTB Datas Transação - De Datas Transação - De RU Даты транзакций с Даты транзакций с S Från transaktionsdatum Från transaktionsdatum TR İşlem Tarihleri: İlk İşlem Tarihleri: İlk US Transaction Dates From Transaction Dates From ZHS 事务处理起始日期 事务处理起始日期 7 50 :p_trx_date_to DateTime AR إلى إلى D Bis Bis E A A F Au Au I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 8 60 :p_receipt_num_from LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) AR أرقام الاستلام من أرقام الاستلام من D Von Wareneingangsnummer Von Wareneingangsnummer E De Número de Recepción De Número de Recepción F Numéros de réception - De Numéros de réception - De I Numeri ricevute - Da Numeri ricevute - Da JA 受入番号:自 受入番号:自 KO 입고 번호: 부터 입고 번호: 부터 PTB Números de Recebimento - De Números de Recebimento - De RU Номера поступлений с Номера поступлений с S Från mottagningsnummer Från mottagningsnummer TR Teslimat Numaraları: İlk Teslimat Numaraları: İlk US Receipt Numbers From Receipt Numbers From ZHS 接收编号自 接收编号自 9 70 :p_receipt_num_to LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) AR إلى 2 إلى D Bis 2 Bis E A 2 A F A A I A 2 A JA 至 2 至 KO 까지 2 까지 PTB Até 2 Até RU По 2 По S Till 2 Till TR Son 2 Son US To 2 To ZHS 至 2 至 10 80 :p_receiver LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR مستلم مستلم D Warenannahme Warenannahme E Receptor Receptor F Bénéficiaire Bénéficiaire I Destinatario Destinatario JA 受入担当 受入担当 KO 입고자 입고자 PTB Recebedor Recebedor RU Получатель Получатель S Mottagare Mottagare TR Teslim Alan Teslim Alan US Receiver Receiver ZHS 接收人 接收人 11 90 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 12 100 :p_item_to Char AR إلى 3 إلى D Bis 3 Bis E A 3 A F A 2 A I A 3 A JA 至 3 至 KO 까지 3 까지 PTB Até 3 Até RU По 3 По S Till 3 Till TR Son 3 Son US To 3 To ZHS 至 3 至 13 110 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 14 120 :p_category_to Char AR إلى 4 إلى D Bis 4 Bis E A 4 A F A 3 A I A 4 A JA 至 4 至 KO 까지 4 까지 PTB Até 4 Até RU По 4 По S Till 4 Till TR Son 4 Son US To 4 To ZHS 至 4 至 15 130 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR الموردون من الموردون من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseurs - De Fournisseurs - De I Fornitori - Da: Fornitori - Da: JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedores - De Fornecedores - De RU Поставщики с Поставщики с S Från leverantörer Från leverantörer TR Tedarikçiler, İlk Tedarikçiler, İlk US Suppliers From Suppliers From ZHS 供应商自 供应商自 16 140 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى 5 إلى D Bis 5 Bis E A 5 A F A 4 A I A 5 A JA 至 5 至 KO 까지 5 까지 PTB Até 5 Até RU По 5 По S Till 5 Till TR Son 5 Son US To 5 To ZHS 至 5 至 17 150 :p_po_num_from LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR أرقام أوامر الشراء من أرقام أوامر الشراء من D Von Bestellnummer Von Bestellnummer E De Números de Pedido de Compra De Números de Pedido de Compra F Numéros d'ordre d'achat - De Numéros d'ordre d'achat - De I Numeri ordine di acquisto - Da Numeri ordine di acquisto - Da JA 発注番号:自 発注番号:自 KO 구매 발주 번호: 부터 구매 발주 번호: 부터 PTB Números de Ordem de Compra - De Números de Ordem de Compra - De RU Номера заказов на приобретение с Номера заказов на приобретение с S Från ordernummer Från ordernummer TR İlk Satın Alma Siparişi Numarası İlk Satın Alma Siparişi Numarası US Purchase Order Numbers From Purchase Order Numbers From ZHS 采购订单编号自 采购订单编号自 18 160 :p_po_num_to LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR إلى 6 إلى D Bis 6 Bis E A 6 A F A 5 A I A 6 A JA 至 6 至 KO 까지 6 까지 PTB Até 6 Até RU По 6 По S Till 6 Till TR Son 6 Son US To 6 To ZHS 至 6 至 19 170 :p_buyer_name LOV Oracle PO_SRS_BUYER_NAME Y select hre.full_name id, hre.full_name value, null description from po_agents poa,hr_employees hre where poa.agent_id=hre.employee_id order by full_name AR اسم المشتري اسم المشتري D Einkäufername Einkäufername E Nombre de Comprador Nombre de Comprador F Nom de l'acheteur Nom de l'acheteur I Nome buyer Nome buyer JA 購買担当名 購買担当名 KO 구매자명 구매자명 PTB Nome do Comprador Nome do Comprador RU Имя покупателя Имя покупателя S Köpare Köpare TR Satın Alan Adı Satın Alan Adı US Buyer Name Buyer Name ZHS 采购员姓名 采购员姓名 20 180 :p_req_num_from LOV Oracle PO_SRS_REQ_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters posp where prh.type_lookup_code='INTERNAL' order by decode(posp.manual_po_num_type,'NUMERIC', to_number(prh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', prh.segment1) AR أرقام طلب الشراء من أرقام طلب الشراء من D Von Anforderungsnummer Von Anforderungsnummer E De Número de Solicitud De Número de Solicitud F Numéros de demande d'approvisionnement - De Numéros de demande d'approvisionnement - De I Numeri RdA - Da Numeri RdA - Da JA 購買依頼番号:自 購買依頼番号:自 KO 구매요청 번호: 부터 구매요청 번호: 부터 PTB Números da Requisição - De Números da Requisição - De RU Номера заявок с Номера заявок с S Från rekvisitionsnummer Från rekvisitionsnummer TR Talep Numaraları, İlk Talep Numaraları, İlk US Requisition Numbers From Requisition Numbers From ZHS 申请编号自 申请编号自 21 190 :p_req_num_to LOV Oracle PO_SRS_REQ_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters posp where prh.type_lookup_code='INTERNAL' order by decode(posp.manual_po_num_type,'NUMERIC', to_number(prh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', prh.segment1) AR إلى 7 إلى D Bis 7 Bis E A 7 A F A 6 A I A 7 A JA 至 7 至 KO 까지 7 까지 PTB Até 7 Até RU По 7 По S Till 7 Till TR Son 7 Son US To 7 To ZHS 至 7 至 22 200 :p_ship_num_from LOV Oracle PO_SRS_SHIPMENT_NUMBER Y select shipment_num id, shipment_num value, null description from rcv_shipment_headers order by shipment_num AR أرقام الشحنات من أرقام الشحنات من D Von Liefernummer Von Liefernummer E De Número de Envío De Número de Envío F Numéros de livraison - De Numéros de livraison - De I Numeri spedizioni - Da Numeri spedizioni - Da JA 納入番号:自 納入番号:自 KO 납품 번호: 부터 납품 번호: 부터 PTB Números da Entrega - De Números da Entrega - De RU Номера поставок с Номера поставок с S Från leveransnummer Från leveransnummer TR Sevkiyat Numaraları: İlk Sevkiyat Numaraları: İlk US Shipment Numbers From Shipment Numbers From ZHS 发运编号自 发运编号自 23 210 :p_ship_num_to LOV Oracle PO_SRS_SHIPMENT_NUMBER Y select shipment_num id, shipment_num value, null description from rcv_shipment_headers order by shipment_num AR إلى 8 إلى D Bis 8 Bis E A 8 A F A 7 A I A 8 A JA 至 8 至 KO 까지 8 까지 PTB Até 8 Até RU По 8 По S Till 8 Till TR Son 8 Son US To 8 To ZHS 至 8 至 24 220 :p_exception LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR الاستثناء الاستثناء D Ausnahme Ausnahme E Excepción Excepción I Eccezione Eccezione JA 例外 例外 KO 예외 예외 PTB Exceção Exceção RU Исключение Исключение S Undantag Undantag TR İstisna İstisna US Exception Exception ZHS 例外 例外 25 230 :p_detail_summary LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE= 'YES_NO' AND LOOKUP_CODE='Y' AR التفاصيل تفاصيل أو إجمالي D Details Details oder Übersicht E Detalle Detalle o Resumen F Détail Détail ou synthèse I Dettaglio Dettaglio o sintetico JA 詳細 詳細または要約 KO 상세내역 상세내역 혹은 요약 PTB Detalhe Detalhe ou Sumário RU Подробный Подробный или сводный S Detalj Detalj eller översikt TR Detay Detay veya Özet US Detail Detail or Summary ZHS 详细信息 明细或汇总 26 240 :p_inc_lot_and_serial LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE= 'YES_NO' AND LOOKUP_CODE = 'N' AR تضمين لوط/مسلسل تضمين لوط/مسلسل D Mit Los/Serie Mit Los/Serie E Incluir Lote/Nº Serie Incluir Lote/Nº Serie F Inclure lot/série Inclure lot/série I Includi numeri di lotto/serie Includi numeri di lotto/serie JA ロット/シリアル番号を含む ロット/シリアル番号を含む KO 로트/일련번호 포함 로트/일련번호 포함 PTB Incluir Lote/Série Incluir Lote/Série RU Включить партию/серийный номер Включить партию/серийный номер S Inkludera parti/serie Inkludera parti/serie TR Lot/Seri Dahil Lot/Seri Dahil US Include Lot/Serial Include Lot/Serial ZHS 包括批次/系列 包括批次/系列 27 250 :p_customer_from LOV Oracle PO_SRS_CUSTOMER Y select name id, name value, null description from oe_sold_to_orgs_v order by name AR العملاء من العملاء من D Von Kunde Von Kunde E De Cliente De Cliente F Clients - De Clients - De I Clienti - Da Clienti - Da JA 顧客:自 顧客:自 KO 고객: 부터 고객: 부터 PTB Clientes - De Clientes - De RU Заказчики с Заказчики с S Från kunder Från kunder TR Müşteriler, İlk Müşteriler, İlk US Customers From Customers From ZHS 客户自 客户自 28 260 :p_customer_to LOV Oracle PO_SRS_CUSTOMER Y select name id, name value, null description from oe_sold_to_orgs_v order by name AR إلى 9 إلى D Bis 9 Bis E A 9 A F A 8 A I A 9 A JA 至 9 至 KO 까지 9 까지 PTB Até 9 Até RU По 9 По S Till 9 Till TR Son 9 Son US To 9 To ZHS 至 9 至 29 270 :p_rma_num_from LOV Oracle PO_SRS_TRNX_RMA Y select order_number id, order_number value, null description from oe_order_headers oeh where exists (select oe_order_header_id from rcv_transactions rct where rct.oe_order_header_id=oeh.header_id) order by value,description AR أرقام RMA من أرقام RMA من D Von Rücksendungsnummer Von Rücksendungsnummer E De Números de Autorización de Devolución de Material De Números de Autorización de Devolución de Material F Numéros d'autorisation de retour client - De Numéros d'autorisation de retour client - De I Numeri RMA - Da Numeri RMA - Da JA RMA番号:自 RMA番号:自 KO RMA 번호-부터 RMA 번호-부터 PTB Números de RMA - De Números de RMA - De RU Номера РВМ с Номера РВМ с S Från RMA-nr Från RMA-nr TR RMA Numaraları, İlk RMA Numaraları, İlk US RMA Numbers From RMA Numbers From ZHS RMA 编号自 RMA 编号自 30 280 :p_rma_num_to LOV Oracle PO_SRS_TRNX_RMA Y select order_number id, order_number value, null description from oe_order_headers oeh where exists (select oe_order_header_id from rcv_transactions rct where rct.oe_order_header_id=oeh.header_id) order by value,description AR إلى 10 إلى D Bis 10 Bis E A 10 A F A 9 A I A 10 A JA 至 10 至 KO 까지 10 까지 PTB Até 10 Até RU По 10 По S Till 10 Till TR Son 10 Son US To 10 To ZHS 至 10 至 :$flex$.po_srs_organizations Organization Receipt Numbers From :$flex$.po_srs_organizations Organization To 2