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 1057: , po_lines_all pol

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
1061: AND (TRUNC(NVL(pol.expiration_date,SYSDATE )) >= TRUNC(SYSDATE))

Line 1700: FROM po_lines_all

1696: --, po_line_id
1697: INTO
1698: l_purchasing_uom
1699: --, l_po_line_id
1700: FROM po_lines_all
1701: WHERE po_header_id = l_blanket_id
1702: AND item_id = l_item_id
1703: AND po_line_id = l_po_line_id --bug 12580131,
1704: AND ROWNUM = 1;

Line 2022: po_lines_all pla

2018: , 'Consumption Advice'
2019: , l_secondary_quantity --/* INVCONV
2020: , l_secondary_uom --/* INVCONV
2021: FROM
2022: po_lines_all pla
2023: WHERE po_header_id = l_blanket_id
2024: AND item_id = l_item_id
2025: AND po_line_id=l_po_line_id;
2026: --Bug 11900144. removed rownum condition and added po_line_id

Line 3154: l_header_id po_lines_all.po_header_id%TYPE;

3150: l_item_revision t_item_revision;
3151: l_vendor_site_id t_OWNING_ORGANIZATION_ID;
3152: l_organization_id t_organization_id;
3153: l_transaction_date t_transaction_date;
3154: l_header_id po_lines_all.po_header_id%TYPE;
3155: l_document_line_id po_lines_all.po_line_id%TYPE;
3156: l_global_flag varchar(2);
3157:
3158: CURSOR csr_null_po_line_id IS

Line 3155: l_document_line_id po_lines_all.po_line_id%TYPE;

3151: l_vendor_site_id t_OWNING_ORGANIZATION_ID;
3152: l_organization_id t_organization_id;
3153: l_transaction_date t_transaction_date;
3154: l_header_id po_lines_all.po_header_id%TYPE;
3155: l_document_line_id po_lines_all.po_line_id%TYPE;
3156: l_global_flag varchar(2);
3157:
3158: CURSOR csr_null_po_line_id IS
3159: SELECT mmt.transaction_id ,

Line 3239: from po_lines_All

3235: -- If po_line_id remains null , it will not be processed at all and manual datafix
3236: -- needs to be applied to resolve this extreemly corner case.
3237: select po_line_id
3238: into l_document_line_id
3239: from po_lines_All
3240: where po_header_id = l_transaction_source_id(i)
3241: and item_id = l_inventory_item_id(i)
3242: and rownum = 1 ;
3243: INV_LOG_UTIL.trace('Derived po_line_id is '||l_document_line_id,'INV_CONSUMPTION_ADVICE_PROC',9);