APPS.PO_CATALOG_INDEX_PVT dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 1329: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1325: AND POH.global_agreement_flag = 'Y'
1326: AND POGA.po_header_id = POH.po_header_id
1327: AND ( NOT EXISTS
1328: (SELECT 'Headers were archived'
1329: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1330: WHERE ARCH.org_assignment_id = POGA.org_assignment_id))
1331: UNION ALL
1332: SELECT
1333: l_key_org_assignments

Line 1348: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1344: AND POH.global_agreement_flag = 'Y'
1345: AND POGA.po_header_id = POH.po_header_id
1346: AND EXISTS
1347: (SELECT 'Only Enabled/disabled flag is modified'
1348: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1349: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1350: AND ARCH.latest_external_flag = 'Y'
1351: AND ARCH.enabled_flag <> POGA.enabled_flag
1352: AND ARCH.purchasing_org_id = POGA.purchasing_org_id

Line 1371: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1367: AND POH.global_agreement_flag = 'Y'
1368: AND POGA.po_header_id = POH.po_header_id
1369: AND EXISTS
1370: (SELECT 'Only Purch Org/Purch Site is modified'
1371: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1372: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1373: AND ARCH.latest_external_flag = 'Y'
1374: AND (ARCH.purchasing_org_id <> POGA.purchasing_org_id OR
1375: ARCH.vendor_site_id <> POGA.vendor_site_id)

Line 1394: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH

1390: AND POH.global_agreement_flag = 'Y'
1391: AND POGA.po_header_id = POH.po_header_id
1392: AND EXISTS
1393: (SELECT 'Both enable_flag AND Purch Org/Purch Site are modified'
1394: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE ARCH
1395: WHERE ARCH.org_assignment_id = POGA.org_assignment_id
1396: AND ARCH.latest_external_flag = 'Y'
1397: AND (ARCH.purchasing_org_id <> POGA.purchasing_org_id OR
1398: ARCH.vendor_site_id <> POGA.vendor_site_id)