DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on PO_LINES_ALL

Line 787: line_num po_lines_all.line_num%TYPE,

783:
784: TYPE asn_lines_record is record (
785: po_num po_headers_all.CLM_DOCUMENT_NUMBER%TYPE,
786: po_rev_no po_headers_all.revision_num%TYPE,
787: line_num po_lines_all.line_num%TYPE,
788: ship_num po_line_locations_all.shipment_num%TYPE,
789: item_num varchar2(80),
790: item_desc po_lines_all.item_description%TYPE,
791: uom po_lines_all.unit_meas_lookup_code%TYPE,

Line 790: item_desc po_lines_all.item_description%TYPE,

786: po_rev_no po_headers_all.revision_num%TYPE,
787: line_num po_lines_all.line_num%TYPE,
788: ship_num po_line_locations_all.shipment_num%TYPE,
789: item_num varchar2(80),
790: item_desc po_lines_all.item_description%TYPE,
791: uom po_lines_all.unit_meas_lookup_code%TYPE,
792: order_qty po_line_locations_all.quantity%TYPE,
793: ship_qty rcv_transactions_interface.quantity%TYPE,
794: --rcvd_qty po_line_locations_all.quantity_received%type,

Line 791: uom po_lines_all.unit_meas_lookup_code%TYPE,

787: line_num po_lines_all.line_num%TYPE,
788: ship_num po_line_locations_all.shipment_num%TYPE,
789: item_num varchar2(80),
790: item_desc po_lines_all.item_description%TYPE,
791: uom po_lines_all.unit_meas_lookup_code%TYPE,
792: order_qty po_line_locations_all.quantity%TYPE,
793: ship_qty rcv_transactions_interface.quantity%TYPE,
794: --rcvd_qty po_line_locations_all.quantity_received%type,
795: rcvd_qty NUMBER,

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

856: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
857: ood.ORGANIZATION_CODE ORGANIZATION_CODE
858: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,
859: org_organization_definitions ood,po_releases_all prl,
860: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
861: hr_locations_all_tl hrl, hz_locations hz
862: WHERE rhi.header_interface_id=rti.header_interface_id and
863: rhi.shipment_num= p_shipment_num and
864: pola.po_line_id = rti.po_line_id and

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

888: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
889: ood.ORGANIZATION_CODE ORGANIZATION_CODE
890: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh ,
891: org_organization_definitions ood,po_releases_all prl,
892: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
893: hr_locations_all_tl hrl,hz_locations hz
894: WHERE rsh.shipment_header_id=rsl.shipment_header_id and
895: rsh.shipment_num= p_shipment_num and
896: pola.po_line_id = rsl.po_line_id and