APPS.PO_CATALOG_INDEX_PVT dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 1293: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1289: AND POH.global_agreement_flag = 'Y'
1290: AND POGA.po_header_id = POH.po_header_id
1291: AND ( NOT EXISTS
1292: (SELECT 'Headers were archived'
1293: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1294: WHERE ARCH.org_assignment_id = POGA.org_assignment_id))
1295: UNION ALL
1296: SELECT
1297: l_key_org_assignments

Line 1312: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1308: AND POH.global_agreement_flag = 'Y'
1309: AND POGA.po_header_id = POH.po_header_id
1310: AND EXISTS
1311: (SELECT 'Only Enabled/disabled flag is modified'
1312: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1313: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1314: AND ARCH.latest_external_flag = 'Y'
1315: AND ARCH.enabled_flag <> POGA.enabled_flag
1316: AND ARCH.purchasing_org_id = POGA.purchasing_org_id

Line 1335: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1331: AND POH.global_agreement_flag = 'Y'
1332: AND POGA.po_header_id = POH.po_header_id
1333: AND EXISTS
1334: (SELECT 'Only Purch Org/Purch Site is modified'
1335: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1336: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1337: AND ARCH.latest_external_flag = 'Y'
1338: AND (ARCH.purchasing_org_id <> POGA.purchasing_org_id OR
1339: ARCH.vendor_site_id <> POGA.vendor_site_id)

Line 1358: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1354: AND POH.global_agreement_flag = 'Y'
1355: AND POGA.po_header_id = POH.po_header_id
1356: AND EXISTS
1357: (SELECT 'Both enable_flag AND Purch Org/Purch Site are modified'
1358: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1359: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1360: AND ARCH.latest_external_flag = 'Y'
1361: AND (ARCH.purchasing_org_id <> POGA.purchasing_org_id OR
1362: ARCH.vendor_site_id <> POGA.vendor_site_id)