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 1056: po_headers_all poh

1052: COUNT(1)
1053: INTO
1054: l_count
1055: FROM
1056: po_headers_all poh
1057: , po_lines_all pol
1058: WHERE poh.po_header_id = pol.po_header_id
1059: AND (TRUNC(NVL(poh.start_date,SYSDATE -1)) <= TRUNC(SYSDATE))
1060: AND (TRUNC(NVL(poh.end_date+NVL(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0),SYSDATE +1)) >= TRUNC(SYSDATE)) -- Bug 8397146

Line 1527: po_headers_all

1523: segment1
1524: INTO
1525: l_document_number
1526: FROM
1527: po_headers_all
1528: WHERE po_header_id = l_blanket_id;
1529:
1530: ELSE
1531: l_document_number := NULL;

Line 1634: po_headers_all

1630: , 'DEFAULT'
1631: , 'NEW'
1632: , l_current_org_id
1633: FROM
1634: po_headers_all
1635: WHERE po_header_id = l_blanket_id;
1636:
1637:
1638: -- Now fetch info. related to the lines that we need to insert

Line 1928: po_headers_all

1924: ship_to_location_id
1925: INTO
1926: l_header_ship_to_location
1927: FROM
1928: po_headers_all
1929: WHERE po_header_id = l_blanket_id;
1930:
1931: -- Bug Fix for 3959073
1932: -- Getting the location of the Inventory Organization

Line 3578: FROM po_headers_all poa

3574: -- Update the temp table with the currency of the blanket
3575:
3576: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
3577: SET mctt.currency_code = (SELECT poa.currency_code
3578: FROM po_headers_all poa
3579: WHERE poa.po_header_id
3580: = l_txn_source_tab(i))
3581: ,mctt.asl_id = l_asl_id
3582: WHERE mctt.transaction_source_id = l_txn_source_tab(i)

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

4619:
4620:
4621: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
4622: SET (mct.global_agreement_flag) =
4623: (SELECT NVL(global_agreement_flag,'N') FROM po_headers_all
4624: WHERE po_header_id = mct.transaction_source_id)
4625: WHERE mct.consumption_processed_flag IN ('N', 'E')
4626: AND mct.batch_id = l_batch_id;
4627: