APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_HEADERS_ALL

Line 387: FROM po_headers_all

383: THEN
384: BEGIN
385: SELECT segment1
386: INTO l_blanket_po_number
387: FROM po_headers_all
388: WHERE po_header_id = p_consumption_po_header_id;
389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN

Line 1265: po_headers_all poh

1261: COUNT(1)
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))

Line 1732: po_headers_all

1728: segment1
1729: INTO
1730: l_document_number
1731: FROM
1732: po_headers_all
1733: WHERE po_header_id = l_blanket_id;
1734:
1735: ELSE
1736: l_document_number := NULL;

Line 1839: po_headers_all

1835: , 'DEFAULT'
1836: , 'NEW'
1837: , l_current_org_id
1838: FROM
1839: po_headers_all
1840: WHERE po_header_id = l_blanket_id;
1841:
1842:
1843: -- Now fetch info. related to the lines that we need to insert

Line 2129: po_headers_all

2125: ship_to_location_id
2126: INTO
2127: l_header_ship_to_location
2128: FROM
2129: po_headers_all
2130: WHERE po_header_id = l_blanket_id;
2131:
2132: -- Bug Fix for 3959073
2133: -- Getting the location of the Inventory Organization

Line 3720: FROM po_headers_all poa

3716: -- Update the temp table with the currency of the blanket
3717:
3718: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
3719: SET mctt.currency_code = (SELECT poa.currency_code
3720: FROM po_headers_all poa
3721: WHERE poa.po_header_id
3722: = l_txn_source_tab(i))
3723: ,mctt.asl_id = l_asl_id
3724: WHERE mctt.transaction_source_id = l_txn_source_tab(i)

Line 4859: (SELECT NVL(global_agreement_flag,'N') FROM po_headers_all

4855:
4856:
4857: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
4858: SET (mct.global_agreement_flag) =
4859: (SELECT NVL(global_agreement_flag,'N') FROM po_headers_all
4860: WHERE po_header_id = mct.transaction_source_id)
4861: WHERE mct.consumption_processed_flag IN ('N', 'E')
4862: AND mct.batch_id = l_batch_id;
4863: /* Bug: 5092489 Following code block is commented.