APPS.PO_CATALOG_INDEX_PVT dependencies on PO_LINES_ALL

Line 331: FROM PO_LINES_ALL

327: SELECT l_key
328: , po_line_id -- PO_LINE_ID (for Quotation Line): Required by iProc
329: , po_header_id -- PO_HEADER_ID (for Quotation Header): Internal to PO
330: , 'QUOTATION' -- DATA INFO: Internal to PO
331: FROM PO_LINES_ALL
332: WHERE po_header_id = p_po_header_id;
333:
334: l_num_rows_is_gt := SQL%rowcount;
335:

Line 797: FROM PO_LINES_ALL POL

793: , NULL -- Language: n/a if line_changed_flag is Y
794: , POH.global_agreement_flag -- Global Agreement Flag
795: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
796: , 'BLANKET:HEADER' -- DATA INFO: Internal to PO
797: FROM PO_LINES_ALL POL
798: , PO_HEADERS_ALL POH
799: , PO_SESSION_GT GT_REMAINING_HDRS
800: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
801: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 906: FROM PO_LINES_ALL POL

902: , NULL -- Language: n/a if line_changed_flag is Y
903: , POH.global_agreement_flag -- Global Agreement Flag
904: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
905: , 'BLANKET:LINE' -- DATA INFO: Internal to PO
906: FROM PO_LINES_ALL POL
907: , PO_HEADERS_ALL POH
908: , PO_SESSION_GT GT_REMAINING_HDRS
909: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
910: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1023: FROM PO_LINES_ALL POL

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

Line 1108: FROM PO_LINES_ALL POL

1104: , POTLP.language -- Language
1105: , POH.global_agreement_flag -- Global Agreement Flag
1106: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1107: , 'BLANKET:TLP' -- DATA INFO: Internal to PO
1108: FROM PO_LINES_ALL POL
1109: , PO_HEADERS_ALL POH
1110: , PO_ATTRIBUTE_VALUES_TLP POTLP
1111: , PO_SESSION_GT GT_REMAINING_HDRS
1112: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers

Line 1508: FROM PO_LINES_ALL POL,

1504: BULK COLLECT INTO
1505: l_po_line_id_list,
1506: l_item_description_list,
1507: l_created_lang_list
1508: FROM PO_LINES_ALL POL,
1509: PO_HEADERS_ALL POH,
1510: PO_SESSION_GT INPUT_HDRS
1511: WHERE POH.po_header_id = INPUT_HDRS.index_num1
1512: AND INPUT_HDRS.key = l_key /* Bug 6942699 - Added the condition to improve performance */

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

1674:
1675: END IF;
1676:
1677: l_progress := '040';
1678: -- Get the list of item category ids from PO_LINES_ALL
1679: SELECT POL.po_line_id,
1680: POL.category_id,
1681: POATR.ip_category_id
1682: BULK COLLECT INTO

Line 1686: FROM PO_LINES_ALL POL,

1682: BULK COLLECT INTO
1683: l_po_line_id_list,
1684: l_category_id_list,
1685: l_old_ip_category_id_list
1686: FROM PO_LINES_ALL POL,
1687: PO_HEADERS_ALL POH,
1688: PO_ATTRIBUTE_VALUES POATR,
1689: PO_SESSION_GT INPUT_HDRS
1690: WHERE POH.po_header_id = INPUT_HDRS.index_num1