APPS.PO_CATALOG_INDEX_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1321: , PO_GA_ORG_ASSIGNMENTS POGA

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
1325: AND POH.global_agreement_flag = 'Y'

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 1340: , PO_GA_ORG_ASSIGNMENTS POGA

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
1344: AND POH.global_agreement_flag = 'Y'

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 1363: , PO_GA_ORG_ASSIGNMENTS POGA

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
1367: AND POH.global_agreement_flag = 'Y'

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 1386: , PO_GA_ORG_ASSIGNMENTS POGA

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
1390: AND POH.global_agreement_flag = 'Y'

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)