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 RCV_HEADERS_INTERFACE

Line 411: RCV_HEADERS_INTERFACE RHI,

407: -- changed cursor re bug 9907309 - not fetching end dated buyer users.
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

Line 858: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,

854: pll.quantity_received QUANTITY_RECEIVED,
855: NVL( HRL.LOCATION_CODE,
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