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.INV_UI_RCV_LOVS dependencies on PO_HEADERS_ALL

Line 44: , po_headers_all poh

40: , poh.note_to_receiver
41: , to_char(poh.org_id) --
42: FROM rcv_supply ms
43: , rcv_transactions rt
44: , po_headers_all poh
45: , po_lines_all pol
46: , po_line_types plt
47: , mtl_parameters mp
48: WHERE poh.po_header_id = ms.po_header_id

Line 93: po_Headers_All poh ,

89: to_char(poh.org_id) --
90:
91: FROM rcv_Supply ms ,
92: rcv_Transactions rt,
93: po_Headers_All poh ,
94: mtl_Parameters mp
95: WHERE poh.po_Header_Id = ms.po_Header_Id
96: AND ms.Quantity > 0
97: AND ms.Supply_Type_Code = 'RECEIVING'

Line 201: FROM po_headers_all poh

197: , poh.vendor_site_id
198: , 'Vendor'
199: , poh.note_to_receiver
200: , to_char(poh.org_id) --
201: FROM po_headers_all poh
202: , rcv_shipment_lines rsl
203: WHERE exists (SELECT 'Valid PO Shipments'
204: FROM po_line_locations poll
205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

Line 254: PO_HEADERS_ALL POH,

250: RCV_TRANSACTIONS RT,
251: PO_LOOKUP_CODES PLC,
252: PO_LINES_ALL pol,
253: PO_LINE_LOCATIONS_ALL PLL,
254: PO_HEADERS_ALL POH,
255: po_line_types plt,--BUG 5166887
256: mtl_parameters mp --BUG 5166887
257: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not
258: , rcv_parameters rp

Line 944: (select '1' from po_headers_all poh

940: WHERE msik.inventory_item_id = rsl.item_id
941: AND msik.organization_id = p_organization_id
942: AND msik.mtl_transactions_enabled_flag = 'N')
943: OR exists
944: (select '1' from po_headers_all poh
945: , po_lines_all pol
946: , po_line_types plt
947: where rt.po_header_id is not null
948: and rt.po_header_id = poh.po_header_id

Line 1115: from po_headers_all poh

1111: WHERE msik.inventory_item_id = rsl.item_id
1112: AND msik.organization_id = p_organization_id
1113: AND msik.mtl_transactions_enabled_flag = 'N')
1114: OR exists (select '1'
1115: from po_headers_all poh
1116: , po_lines_all pol
1117: , po_line_types plt
1118: where rt.po_header_id is not null
1119: and rt.po_header_id = poh.po_header_id

Line 3041: FROM po_headers_all phl

3037: , woov.department_code
3038: , pda.po_distribution_id
3039: , (pda.quantity_ordered - pda.quantity_delivered)
3040: , woov.repetitive_schedule_id
3041: FROM po_headers_all phl
3042: , po_lines_all pla
3043: , po_distributions_all pda
3044: , po_releases_all prl
3045: , wip_osp_jobs_val_v wojv

Line 3079: FROM po_headers_all phl

3075: , woov.department_code
3076: , pda.po_distribution_id
3077: , (pda.quantity_ordered - pda.quantity_delivered)
3078: , woov.repetitive_schedule_id
3079: FROM po_headers_all phl
3080: , po_lines_all pla
3081: , po_distributions_all pda
3082: , wip_osp_jobs_val_v wojv
3083: , wip_osp_lines_val_v wolv