APPS.PO_CATALOG_INDEX_PVT dependencies on PO_LINES_ALL

Line 337: FROM PO_LINES_ALL

333: SELECT l_key
334: , po_line_id -- PO_LINE_ID (for Quotation Line): Required by iProc
335: , po_header_id -- PO_HEADER_ID (for Quotation Header): Internal to PO
336: , 'QUOTATION' -- DATA INFO: Internal to PO
337: FROM PO_LINES_ALL
338: WHERE po_header_id = p_po_header_id
339: and last_update_date between sysdate-1 and sysdate+1;
340:
341: l_num_rows_is_gt := SQL%rowcount;

Line 805: FROM PO_LINES_ALL POL

801: , NULL -- Language: n/a if line_changed_flag is Y
802: , POH.global_agreement_flag -- Global Agreement Flag
803: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
804: , 'BLANKET:HEADER' -- DATA INFO: Internal to PO
805: FROM PO_LINES_ALL POL
806: , PO_HEADERS_ALL POH
807: , PO_SESSION_GT GT_REMAINING_HDRS
808: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
809: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 914: FROM PO_LINES_ALL POL

910: , NULL -- Language: n/a if line_changed_flag is Y
911: , POH.global_agreement_flag -- Global Agreement Flag
912: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
913: , 'BLANKET:LINE' -- DATA INFO: Internal to PO
914: FROM PO_LINES_ALL POL
915: , PO_HEADERS_ALL POH
916: , PO_SESSION_GT GT_REMAINING_HDRS
917: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
918: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1018: FROM PO_LINES_ALL POL

1014: , NULL -- Language: n/a if line_changed_flag is Y
1015: , POH.global_agreement_flag -- Global Agreement Flag
1016: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1017: , 'BLANKET:ATTR' -- DATA INFO: Internal to PO
1018: FROM PO_LINES_ALL POL
1019: , PO_HEADERS_ALL POH
1020: , PO_ATTRIBUTE_VALUES POATR
1021: , PO_SESSION_GT GT_REMAINING_HDRS
1022: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers

Line 1124: FROM PO_LINES_ALL POL

1120: , POTLP.language -- Language
1121: , POH.global_agreement_flag -- Global Agreement Flag
1122: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1123: , 'BLANKET:TLP' -- DATA INFO: Internal to PO
1124: FROM PO_LINES_ALL POL
1125: , PO_HEADERS_ALL POH
1126: , PO_ATTRIBUTE_VALUES_TLP POTLP
1127: , PO_SESSION_GT GT_REMAINING_HDRS
1128: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers

Line 1546: FROM PO_LINES_ALL POL,

1542: BULK COLLECT INTO
1543: l_po_line_id_list,
1544: l_item_description_list,
1545: l_created_lang_list
1546: FROM PO_LINES_ALL POL,
1547: PO_HEADERS_ALL POH,
1548: PO_SESSION_GT INPUT_HDRS
1549: WHERE POH.po_header_id = INPUT_HDRS.index_num1
1550: AND INPUT_HDRS.key = l_key -- Bug 6942699 - Added the condition to improve performance

Line 1716: -- Get the list of item category ids from PO_LINES_ALL

1712:
1713: END IF;
1714:
1715: l_progress := '040';
1716: -- Get the list of item category ids from PO_LINES_ALL
1717: SELECT POL.po_line_id,
1718: POL.category_id,
1719: POATR.ip_category_id
1720: BULK COLLECT INTO

Line 1724: FROM PO_LINES_ALL POL,

1720: BULK COLLECT INTO
1721: l_po_line_id_list,
1722: l_category_id_list,
1723: l_old_ip_category_id_list
1724: FROM PO_LINES_ALL POL,
1725: PO_HEADERS_ALL POH,
1726: PO_ATTRIBUTE_VALUES POATR,
1727: PO_SESSION_GT INPUT_HDRS
1728: WHERE POH.po_header_id = INPUT_HDRS.index_num1