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_R12_CAT_UPG_FINAL_GRP dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 2296: -- SQL What: Insert data into PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2292: END LOOP; -- archive attribute_tlp_values
2293:
2294: l_progress := '210';
2295: -- Archive the org_assignments table
2296: -- SQL What: Insert data into PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2297: -- SQL Why : To archive org assignments
2298: -- SQL Join: po_header_id
2299: FORALL i IN 1.. p_po_header_ids.COUNT
2300: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 2300: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2296: -- SQL What: Insert data into PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2297: -- SQL Why : To archive org assignments
2298: -- SQL Join: po_header_id
2299: FORALL i IN 1.. p_po_header_ids.COUNT
2300: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2301: (
2302: po_header_id,
2303: organization_id,
2304: enabled_flag,

Line 2334: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGAA2

2330: FROM PO_GA_ORG_ASSIGNMENTS POGA
2331: WHERE po_header_id = p_po_header_ids(i)
2332: AND NOT EXISTS
2333: (SELECT 'Archive record for Org Assignement already exists'
2334: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGAA2
2335: WHERE POGAA2.org_assignment_id = POGA.org_assignment_id);
2336:
2337: l_progress := '220';
2338: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of org assignment archive records inserted='||SQL%rowcount); END IF;