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_HEADERS_ALL

Line 412: PO_HEADERS_ALL POH,

408: CURSOR asn_buyer(v_shipment_num varchar2,v_vendor_id number,v_vendor_site_id number) is
409: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
410: FROM RCV_TRANSACTIONS_INTERFACE RTI,
411: RCV_HEADERS_INTERFACE RHI,
412: PO_HEADERS_ALL POH,
413: PO_RELEASES_ALL POR,
414: WF_USERS WUSR
415: WHERE POH.PO_HEADER_ID = RTI.PO_HEADER_ID AND
416: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND

Line 431: PO_HEADERS_ALL POH,

427: UNION
428: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
429: FROM RCV_SHIPMENT_LINES RSL,
430: RCV_SHIPMENT_HEADERS RSH,
431: PO_HEADERS_ALL POH,
432: PO_RELEASES_ALL POR,
433: WF_USERS WUSR
434: WHERE
435: POH.PO_HEADER_ID = RSL.PO_HEADER_ID AND

Line 785: po_num po_headers_all.CLM_DOCUMENT_NUMBER%TYPE,

781: document_type in OUT NOCOPY varchar2)
782: IS
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),

Line 786: po_rev_no po_headers_all.revision_num%TYPE,

782: IS
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,

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