APPS.PO_CATALOG_INDEX_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1285: , PO_GA_ORG_ASSIGNMENTS POGA

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

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

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

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

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

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

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

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)