APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_LINES_ALL

Line 186: po_lines_all pol

182: MTL_CONSUMPTION_TRANSACTIONS mct,
183: --MTL_MATERIAL_TRANSACTIONS mmt,
184: po_line_locations_all poll,
185: po_distributions_all pod,
186: po_lines_all pol
187: WHERE mct.transaction_id = l_transaction_id
188: AND mct.consumption_processed_flag = 'Y'
189: AND mct.inventory_item_id = pol.item_id
190: AND mct.transaction_source_id = pol.po_header_id

Line 229: po_lines_all pol

225: MTL_CONSUMPTION_TRANSACTIONS mct,
226: --MTL_MATERIAL_TRANSACTIONS mmt,
227: po_line_locations_all poll,
228: po_distributions_all pod,
229: po_lines_all pol
230: WHERE mct.transaction_id = l_transaction_id
231: AND mct.consumption_processed_flag = 'Y'
232: AND mct.inventory_item_id = pol.item_id
233: AND pol.from_header_id = mct.transaction_source_id

Line 1266: , po_lines_all pol

1262: INTO
1263: l_count
1264: FROM
1265: po_headers_all poh
1266: , po_lines_all pol
1267: WHERE poh.po_header_id = pol.po_header_id
1268: AND (TRUNC(NVL(poh.start_date,SYSDATE -1)) <= TRUNC(SYSDATE))
1269: AND (TRUNC(NVL(poh.end_date,SYSDATE +1)) >= TRUNC(SYSDATE))
1270: AND (TRUNC(NVL(pol.expiration_date,SYSDATE )) >= TRUNC(SYSDATE))

Line 1902: FROM po_lines_all

1898: --, po_line_id
1899: INTO
1900: l_purchasing_uom
1901: --, l_po_line_id
1902: FROM po_lines_all
1903: WHERE po_header_id = l_blanket_id
1904: AND item_id = l_item_id
1905: AND ROWNUM = 1;
1906:

Line 2221: po_lines_all pla

2217: , 'Consumption Advice'
2218: , l_secondary_quantity --/* INVCONV
2219: , l_secondary_uom --/* INVCONV
2220: FROM
2221: po_lines_all pla
2222: WHERE po_header_id = l_blanket_id
2223: AND item_id = l_item_id
2224: and ROWNUM = 1;
2225:

Line 2297: po_lines_all pla

2293: , 'Consumption Advice'
2294: , l_secondary_quantity --/* INVCONV
2295: , l_secondary_uom --/* INVCONV
2296: FROM
2297: po_lines_all pla
2298: WHERE po_header_id = l_blanket_id
2299: AND item_id = l_item_id
2300:
2301: /* Start Bug 6388514 If there are two lines on a blanket with the same item/price, etc,