ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US F1A2B3C4D5E6F7081920A1B2C3D4E5F6 select null action_, null status_, null message_, null modified_columns_, to_number(null) request_id_, to_char(null) row_id, mp.organization_code, aps.vendor_name supplier, assa.vendor_site_code supplier_site, pha.segment1 po_number, pla.line_num, plla.shipment_num, msibk.concatenated_segments item, pla.item_revision, pla.item_description, plla.quantity quantity_ordered, nvl(plla.quantity_received,0) quantity_received, plla.quantity-nvl(plla.quantity_received,0) quantity_remaining, pla.unit_meas_lookup_code unit_of_measure, to_number(null) quantity, to_date(null) transaction_date, (select xxen_util.meaning(pda.destination_type_code,'DESTINATION TYPE',201) from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) destination_type, (select pda.destination_subinventory from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) subinventory, to_char(null) locator, (select hla.location_code from hr_locations_all hla where hla.location_id=(select pda.deliver_to_location_id from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1)) deliver_to_location, (select ft.territory_short_name from fnd_territories_vl ft where ft.territory_code=plla.country_of_origin_code) country_of_origin, to_char(null) vendor_lot_num, to_char(null) comments from po_headers_all pha, ap_suppliers aps, ap_supplier_sites_all assa, po_lines_all pla, po_line_locations_all plla, mtl_parameters mp, mtl_system_items_b_kfv msibk where pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id(+) and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.ship_to_organization_id=mp.organization_id and pla.item_id=msibk.inventory_item_id(+) and plla.ship_to_organization_id=msibk.organization_id(+) and plla.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and nvl(plla.approved_flag,'N')='Y' and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and plla.quantity-nvl(plla.quantity_received,0)>0 and 1=1 Simplified LOVs and WHERE clause to match Oracle standard form shipment-level filtering Y U A xxen_po_upload.upload_receipt xxen_po_upload.do_rcv_import US PO Receiving Transaction Upload PO Receiving Transaction Upload ================================ Create receiving transactions (receipts) against approved standard purchase orders. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can manually enter PO receiving details. Create, Update -------------- Downloads open PO shipment lines with quantities available to receive for the selected organization. The user fills in the Quantity and Transaction Date columns for each line to receive, then uploads. Prerequisites ============= - PO must be approved and not cancelled or closed. - PO shipment must have remaining quantity to receive. - Transaction date must be in an open inventory receiving period. Fields ====== - Organization Code: Required. The receiving inventory organization. - PO Number: Required. The purchase order number. - Line Num: Required. The PO line number. - Shipment Num: Required. The PO shipment number. - Item Revision: Optional. Item revision (defaults from PO line, override for revision-controlled items). - Quantity: Required. The quantity to receive (must be greater than zero). - Transaction Date: Required. The date of the receipt. - Destination Type: Optional. Inventory, Expense, or Shop Floor (defaults from PO distribution). - Subinventory: Optional. Destination subinventory (defaults from PO distribution). - Locator: Optional. Stock locator within the subinventory (required for locator-controlled subinventories). - Deliver To Location: Optional. Override the deliver-to location. - Country of Origin: Optional. Country of origin for trade compliance. - Vendor Lot Num: Optional. Supplier lot number for lot tracking. - Comments: Optional. Receipt comments. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 mp.organization_code=:p_organization LOV custom Y select mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate order by mp.organization_code Y US Organization 3 30 1=1 pha.segment1=:p_po_number LOV custom Y select distinct pha.segment1 value, (select aps.vendor_name from ap_suppliers aps where aps.vendor_id=pha.vendor_id) description from po_headers_all pha, po_line_locations_all plla where pha.po_header_id=plla.po_header_id and plla.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and nvl(plla.approved_flag,'N')='Y' and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') order by 1 US PO Number 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 REQUEST_ID_ Char varchar2 Y 6 ROW_ID Char varchar2 Y Y 7 ORGANIZATION_CODE LOV custom varchar2 Y select mp.organization_id id, mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate order by mp.organization_code Y 8 SUPPLIER Char varchar2 select aps.vendor_name from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, ap_suppliers aps where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.vendor_id=aps.vendor_id Y 9 SUPPLIER_SITE Char varchar2 select assa.vendor_site_code from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, ap_supplier_sites_all assa where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.vendor_site_id=assa.vendor_site_id Y 10 PO_NUMBER LOV custom varchar2 Y Y select distinct pha.segment1 value, (select aps.vendor_name from ap_suppliers aps where aps.vendor_id=pha.vendor_id) description from mtl_parameters mp, po_line_locations_all plla, po_headers_all pha where mp.organization_code=:$column$.organization_code and plla.ship_to_organization_id=mp.organization_id and plla.po_header_id=pha.po_header_id and plla.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and nvl(plla.approved_flag,'N')='Y' and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and plla.quantity-nvl(plla.quantity_received,0)>0 order by 1 Y 11 LINE_NUM LOV custom varchar2 Y select distinct pla.line_num value, pla.item_description description from mtl_parameters mp, po_headers_all pha, po_lines_all pla, po_line_locations_all plla where mp.organization_code=:$column$.organization_code and pha.segment1=:$column$.po_number and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.ship_to_organization_id=mp.organization_id and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and plla.quantity-nvl(plla.quantity_received,0)>0 order by 1 Y 12 SHIPMENT_NUM LOV custom varchar2 Y select plla.shipment_num value, plla.quantity-nvl(plla.quantity_received,0)||' '||pla.unit_meas_lookup_code||' remaining' description from mtl_parameters mp, po_headers_all pha, po_lines_all pla, po_line_locations_all plla where mp.organization_code=:$column$.organization_code and pha.segment1=:$column$.po_number and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.ship_to_organization_id=mp.organization_id and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and plla.quantity-nvl(plla.quantity_received,0)>0 order by 1 Y 13 ITEM Char varchar2 select msibk.concatenated_segments from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, mtl_system_items_b_kfv msibk where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and pla.item_id=msibk.inventory_item_id and plla.ship_to_organization_id=msibk.organization_id and plla.shipment_type<>'BLANKET' Y 14 ITEM_REVISION LOV custom varchar2 select mir.revision value, null description from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, mtl_item_revisions mir where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.item_id=mir.inventory_item_id and mir.organization_id=mp.organization_id order by mir.revision select pla.item_revision from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num 15 ITEM_DESCRIPTION Char varchar2 select pla.item_description from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num Y 16 QUANTITY_ORDERED Number number select plla.quantity from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' Y 17 QUANTITY_RECEIVED Number number select nvl(plla.quantity_received,0) from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' Y 18 QUANTITY_REMAINING Number number select plla.quantity-nvl(plla.quantity_received,0) from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' Y 19 UNIT_OF_MEASURE Char varchar2 select pla.unit_meas_lookup_code from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num Y 20 QUANTITY Number number :$column$.quantity_remaining Y 21 TRANSACTION_DATE Date date sysdate Y 22 DESTINATION_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='DESTINATION TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and nvl(flvv.end_date_active,sysdate)>=sysdate order by flvv.meaning select xxen_util.meaning(pda.destination_type_code,'DESTINATION TYPE',201) from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, po_distributions_all pda where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' and plla.line_location_id=pda.line_location_id and rownum=1 23 SUBINVENTORY LOV custom varchar2 Y select msub.secondary_inventory_name value, msub.description from mtl_parameters mp, mtl_secondary_inventories msub where mp.organization_code=:$column$.organization_code and msub.organization_id=mp.organization_id and nvl(msub.disable_date,sysdate)>=sysdate order by msub.secondary_inventory_name select pda.destination_subinventory from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, po_distributions_all pda where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' and plla.line_location_id=pda.line_location_id and rownum=1 24 LOCATOR LOV custom varchar2 Y Y select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and milk.organization_id=mp.organization_id and milk.subinventory_code=:$column$.subinventory and nvl(milk.disable_date,sysdate)>=sysdate order by milk.concatenated_segments 25 DELIVER_TO_LOCATION LOV custom varchar2 Y Y select hla.location_id id, hla.location_code value, hla.description from hr_locations_all hla where nvl(hla.inactive_date,sysdate)>=sysdate order by hla.location_code select hla.location_code from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, po_distributions_all pda, hr_locations_all hla where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' and plla.line_location_id=pda.line_location_id and pda.deliver_to_location_id=hla.location_id and rownum=1 26 COUNTRY_OF_ORIGIN LOV custom varchar2 Y Y select ft.territory_code id, ft.territory_short_name value, null description from fnd_territories_vl ft where nvl(ft.obsolete_flag,'N')='N' order by ft.territory_short_name select ft.territory_short_name from mtl_parameters mp, org_organization_definitions ood, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, fnd_territories_vl ft where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and pha.segment1=:$column$.po_number and pha.org_id=ood.operating_unit and pha.po_header_id=pla.po_header_id and pla.line_num=:$column$.line_num and pla.po_line_id=plla.po_line_id and plla.shipment_num=:$column$.shipment_num and plla.ship_to_organization_id=mp.organization_id and plla.shipment_type<>'BLANKET' and plla.country_of_origin_code=ft.territory_code 27 VENDOR_LOT_NUM Char varchar2 28 COMMENTS Char varchar2 U 1 p_organization_id in Number ORGANIZATION_CODE U 2 p_po_number in Char PO_NUMBER U 3 p_line_num in Number LINE_NUM U 4 p_shipment_num in Number SHIPMENT_NUM U 5 p_quantity in Number QUANTITY U 6 p_transaction_date in Date TRANSACTION_DATE U 7 p_item_revision in Char ITEM_REVISION U 8 p_destination_type_code in Char DESTINATION_TYPE U 9 p_subinventory in Char SUBINVENTORY U 10 p_locator_id in Number LOCATOR U 11 p_deliver_to_location_id in Number DELIVER_TO_LOCATION U 12 p_country_of_origin_code in Char COUNTRY_OF_ORIGIN U 13 p_vendor_lot_num in Char VENDOR_LOT_NUM U 14 p_comments in Char COMMENTS U 15 p_row_id in/out Char ROW_ID U 16 status_ out Char STATUS_CODE_ U 17 message_ out Char MESSAGE_ P 1 p_organization_id in Number ORGANIZATION_CODE P 2 x_request_id out Number REQUEST_ID_ P 3 status_ out Char STATUS_CODE_ P 4 message_ out Char MESSAGE_ Error SQL Order By organization_code, po_number, line_num, shipment_num Success SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, 'Receipt '||rsh.receipt_num||' created, quantity '||rt.quantity message_, xu.modified_columns_, xu.request_id_, xu.row_id, xu.organization_code, xu.supplier, xu.supplier_site, xu.po_number, xu.line_num, xu.shipment_num, xu.item, xu.item_revision, xu.item_description, xu.quantity_ordered, nvl(plla.quantity_received,0) quantity_received, plla.quantity-nvl(plla.quantity_received,0) quantity_remaining, xu.unit_of_measure, rt.quantity, rt.transaction_date, xu.destination_type, xu.subinventory, xu.locator, xu.deliver_to_location, xu.country_of_origin, xu.vendor_lot_num, xu.comments from xxen_po_receiving_trans_7009_u xu, rcv_transactions rt, rcv_shipment_headers rsh, po_line_locations_all plla, po_lines_all pla, po_headers_all pha where xu.status_code_=xxen_upload.status_success and to_number(xu.row_id)=rt.interface_transaction_id and rt.transaction_type='RECEIVE' and rt.shipment_header_id=rsh.shipment_header_id and rt.po_line_location_id=plla.line_location_id and plla.po_line_id=pla.po_line_id and pla.po_header_id=pha.po_header_id Default value :$column$.line_num LINE_NUM COUNTRY_OF_ORIGIN Default value :$column$.organization_code ORGANIZATION_CODE COUNTRY_OF_ORIGIN Default value :$column$.po_number PO_NUMBER COUNTRY_OF_ORIGIN Default value :$column$.shipment_num SHIPMENT_NUM COUNTRY_OF_ORIGIN Default value :$column$.line_num LINE_NUM DELIVER_TO_LOCATION Default value :$column$.organization_code ORGANIZATION_CODE DELIVER_TO_LOCATION Default value :$column$.po_number PO_NUMBER DELIVER_TO_LOCATION Default value :$column$.shipment_num SHIPMENT_NUM DELIVER_TO_LOCATION Default value :$column$.line_num LINE_NUM DESTINATION_TYPE Default value :$column$.organization_code ORGANIZATION_CODE DESTINATION_TYPE Default value :$column$.po_number PO_NUMBER DESTINATION_TYPE Default value :$column$.shipment_num SHIPMENT_NUM DESTINATION_TYPE Default value :$column$.line_num LINE_NUM ITEM Default value :$column$.organization_code ORGANIZATION_CODE ITEM Default value :$column$.po_number PO_NUMBER ITEM Default value :$column$.shipment_num SHIPMENT_NUM ITEM Default value :$column$.line_num LINE_NUM ITEM_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE ITEM_DESCRIPTION Default value :$column$.po_number PO_NUMBER ITEM_DESCRIPTION Default value :$column$.line_num LINE_NUM ITEM_REVISION LOV query :$column$.line_num LINE_NUM ITEM_REVISION LOV query :$column$.organization_code ORGANIZATION_CODE ITEM_REVISION Default value :$column$.organization_code ORGANIZATION_CODE ITEM_REVISION Default value :$column$.po_number PO_NUMBER ITEM_REVISION LOV query :$column$.po_number PO_NUMBER ITEM_REVISION LOV query :$column$.organization_code ORGANIZATION_CODE LINE_NUM LOV query :$column$.po_number PO_NUMBER LINE_NUM LOV query :$column$.organization_code ORGANIZATION_CODE LOCATOR LOV query :$column$.subinventory SUBINVENTORY LOCATOR LOV query :$column$.organization_code ORGANIZATION_CODE PO_NUMBER Default value :$column$.quantity_remaining QUANTITY_REMAINING QUANTITY Default value :$column$.line_num LINE_NUM QUANTITY_ORDERED Default value :$column$.organization_code ORGANIZATION_CODE QUANTITY_ORDERED Default value :$column$.po_number PO_NUMBER QUANTITY_ORDERED Default value :$column$.shipment_num SHIPMENT_NUM QUANTITY_ORDERED Default value :$column$.line_num LINE_NUM QUANTITY_RECEIVED Default value :$column$.organization_code ORGANIZATION_CODE QUANTITY_RECEIVED Default value :$column$.po_number PO_NUMBER QUANTITY_RECEIVED Default value :$column$.shipment_num SHIPMENT_NUM QUANTITY_RECEIVED Default value :$column$.line_num LINE_NUM QUANTITY_REMAINING Default value :$column$.organization_code ORGANIZATION_CODE QUANTITY_REMAINING Default value :$column$.po_number PO_NUMBER QUANTITY_REMAINING Default value :$column$.shipment_num SHIPMENT_NUM QUANTITY_REMAINING LOV query :$column$.line_num LINE_NUM SHIPMENT_NUM LOV query :$column$.organization_code ORGANIZATION_CODE SHIPMENT_NUM LOV query :$column$.po_number PO_NUMBER SHIPMENT_NUM Default value :$column$.line_num LINE_NUM SUBINVENTORY Default value :$column$.organization_code ORGANIZATION_CODE SUBINVENTORY LOV query :$column$.organization_code ORGANIZATION_CODE SUBINVENTORY Default value :$column$.po_number PO_NUMBER SUBINVENTORY Default value :$column$.shipment_num SHIPMENT_NUM SUBINVENTORY Default value :$column$.organization_code ORGANIZATION_CODE SUPPLIER Default value :$column$.po_number PO_NUMBER SUPPLIER Default value :$column$.organization_code ORGANIZATION_CODE SUPPLIER_SITE Default value :$column$.po_number PO_NUMBER SUPPLIER_SITE Default value :$column$.line_num LINE_NUM UNIT_OF_MEASURE Default value :$column$.organization_code ORGANIZATION_CODE UNIT_OF_MEASURE Default value :$column$.po_number PO_NUMBER UNIT_OF_MEASURE Value to id query :$column$.organization_code ORGANIZATION_CODE p_locator_id Value to id query :$column$.subinventory SUBINVENTORY p_locator_id