eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CATALOG_INDEX_PVT dependencies on PO_HEADERS_ALL

Line 311: l_segment1 PO_HEADERS_ALL.segment1%TYPE;

307: l_key PO_SESSION_GT.key%TYPE;
308: l_return_status VARCHAR2(1);
309: l_num_rows_is_gt NUMBER := 0;
310:
311: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
312: BEGIN
313: IF g_debug_stmt THEN
314: PO_DEBUG.debug_begin(l_log_head);
315: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);

Line 358: FROM PO_HEADERS_ALL

354: );
355:
356: SELECT segment1
357: INTO l_segment1
358: FROM PO_HEADERS_ALL
359: WHERE po_header_id = p_po_header_id;
360:
361: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
362: END IF;

Line 806: , PO_HEADERS_ALL POH

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
810: AND POL.po_header_id = POH.po_header_id

Line 915: , PO_HEADERS_ALL POH

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
919: AND POL.po_header_id = POH.po_header_id

Line 1019: , PO_HEADERS_ALL POH

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
1023: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1125: , PO_HEADERS_ALL POH

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
1129: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1320: FROM PO_HEADERS_ALL POH

1316: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1317: , 'Y' -- Enabled/Disabled changed flag
1318: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1319: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1320: FROM PO_HEADERS_ALL POH
1321: , PO_GA_ORG_ASSIGNMENTS POGA
1322: , PO_SESSION_GT GT_INPUT_HDRS
1323: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1324: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1339: FROM PO_HEADERS_ALL POH

1335: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1336: , 'Y' -- Enabled/Disabled changed flag
1337: , 'N' -- Other fields Changed Flag (Purc Org, Purch Site)
1338: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1339: FROM PO_HEADERS_ALL POH
1340: , PO_GA_ORG_ASSIGNMENTS POGA
1341: , PO_SESSION_GT GT_INPUT_HDRS
1342: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1343: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1362: FROM PO_HEADERS_ALL POH

1358: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1359: , 'N' -- Enabled/Disabled changed flag
1360: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1361: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1362: FROM PO_HEADERS_ALL POH
1363: , PO_GA_ORG_ASSIGNMENTS POGA
1364: , PO_SESSION_GT GT_INPUT_HDRS
1365: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1366: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1385: FROM PO_HEADERS_ALL POH

1381: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1382: , 'Y' -- Enabled/Disabled changed flag
1383: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1384: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1385: FROM PO_HEADERS_ALL POH
1386: , PO_GA_ORG_ASSIGNMENTS POGA
1387: , PO_SESSION_GT GT_INPUT_HDRS
1388: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1389: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1547: PO_HEADERS_ALL POH,

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
1551: AND POL.po_header_id = POH.po_header_id

Line 1725: PO_HEADERS_ALL POH,

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
1729: AND INPUT_HDRS.key = l_key