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 305: l_segment1 PO_HEADERS_ALL.segment1%TYPE;

301: l_key PO_SESSION_GT.key%TYPE;
302: l_return_status VARCHAR2(1);
303: l_num_rows_is_gt NUMBER := 0;
304:
305: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
306: BEGIN
307: IF g_debug_stmt THEN
308: PO_DEBUG.debug_begin(l_log_head);
309: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);

Line 351: FROM PO_HEADERS_ALL

347: );
348:
349: SELECT segment1
350: INTO l_segment1
351: FROM PO_HEADERS_ALL
352: WHERE po_header_id = p_po_header_id;
353:
354: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
355: END IF;

Line 798: , PO_HEADERS_ALL POH

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

Line 907: , PO_HEADERS_ALL POH

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

Line 1024: , PO_HEADERS_ALL POH

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

Line 1109: , PO_HEADERS_ALL POH

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

Line 1284: FROM PO_HEADERS_ALL POH

1280: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1281: , 'Y' -- Enabled/Disabled changed flag
1282: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1283: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1284: FROM PO_HEADERS_ALL POH
1285: , PO_GA_ORG_ASSIGNMENTS POGA
1286: , PO_SESSION_GT GT_INPUT_HDRS
1287: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1288: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1303: FROM PO_HEADERS_ALL POH

1299: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1300: , 'Y' -- Enabled/Disabled changed flag
1301: , 'N' -- Other fields Changed Flag (Purc Org, Purch Site)
1302: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1303: FROM PO_HEADERS_ALL POH
1304: , PO_GA_ORG_ASSIGNMENTS POGA
1305: , PO_SESSION_GT GT_INPUT_HDRS
1306: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1307: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1326: FROM PO_HEADERS_ALL POH

1322: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1323: , 'N' -- Enabled/Disabled changed flag
1324: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1325: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1326: FROM PO_HEADERS_ALL POH
1327: , PO_GA_ORG_ASSIGNMENTS POGA
1328: , PO_SESSION_GT GT_INPUT_HDRS
1329: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1330: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1349: FROM PO_HEADERS_ALL POH

1345: , POGA.org_assignment_id -- ORG_ASSIGNMENT_ID
1346: , 'Y' -- Enabled/Disabled changed flag
1347: , 'Y' -- Other fields Changed Flag (Purc Org, Purch Site)
1348: , 'BLANKET:ORG_ASSIGNMENT' -- DATA INFO: Internal to PO
1349: FROM PO_HEADERS_ALL POH
1350: , PO_GA_ORG_ASSIGNMENTS POGA
1351: , PO_SESSION_GT GT_INPUT_HDRS
1352: WHERE GT_INPUT_HDRS.key = l_key_input_headers
1353: AND POH.po_header_id = GT_INPUT_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID

Line 1509: PO_HEADERS_ALL POH,

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 */
1513: AND POL.po_header_id = POH.po_header_id

Line 1687: PO_HEADERS_ALL POH,

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