eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_ASN_NOTIF dependencies on PO_LINES_ALL

Line 621: line_num po_lines_all.line_num%TYPE,

617:
618: TYPE asn_lines_record is record (
619: po_num po_headers_all.segment1%TYPE,
620: po_rev_no po_headers_all.revision_num%TYPE,
621: line_num po_lines_all.line_num%TYPE,
622: ship_num po_line_locations_all.shipment_num%TYPE,
623: item_num varchar2(80),
624: item_desc po_lines_all.item_description%TYPE,
625: uom po_lines_all.unit_meas_lookup_code%TYPE,

Line 624: item_desc po_lines_all.item_description%TYPE,

620: po_rev_no po_headers_all.revision_num%TYPE,
621: line_num po_lines_all.line_num%TYPE,
622: ship_num po_line_locations_all.shipment_num%TYPE,
623: item_num varchar2(80),
624: item_desc po_lines_all.item_description%TYPE,
625: uom po_lines_all.unit_meas_lookup_code%TYPE,
626: order_qty po_line_locations_all.quantity%TYPE,
627: ship_qty rcv_transactions_interface.quantity%TYPE,
628: --rcvd_qty po_line_locations_all.quantity_received%type,

Line 625: uom po_lines_all.unit_meas_lookup_code%TYPE,

621: line_num po_lines_all.line_num%TYPE,
622: ship_num po_line_locations_all.shipment_num%TYPE,
623: item_num varchar2(80),
624: item_desc po_lines_all.item_description%TYPE,
625: uom po_lines_all.unit_meas_lookup_code%TYPE,
626: order_qty po_line_locations_all.quantity%TYPE,
627: ship_qty rcv_transactions_interface.quantity%TYPE,
628: --rcvd_qty po_line_locations_all.quantity_received%type,
629: rcvd_qty NUMBER,

Line 684: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,

680: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
681: ood.ORGANIZATION_CODE ORGANIZATION_CODE
682: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,
683: org_organization_definitions ood,po_releases_all prl,
684: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
685: hr_locations_all_tl hrl, hz_locations hz
686: WHERE rhi.header_interface_id=rti.header_interface_id and
687: rhi.shipment_num= p_shipment_num and
688: pola.po_line_id = rti.po_line_id and

Line 716: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,

712: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
713: ood.ORGANIZATION_CODE ORGANIZATION_CODE
714: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh ,
715: org_organization_definitions ood,po_releases_all prl,
716: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
717: hr_locations_all_tl hrl,hz_locations hz
718: WHERE rsh.shipment_header_id=rsl.shipment_header_id and
719: rsh.shipment_num= p_shipment_num and
720: pola.po_line_id = rsl.po_line_id and