APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 11798: FROM PO_GA_ORG_ASSIGNMENTS PGOA

11794: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
11795: AND NOT EXISTS
11796: --SQL Query enabled org assignments of this current purchasing org
11797: (SELECT 'Enabled purchasing org'
11798: FROM PO_GA_ORG_ASSIGNMENTS PGOA
11799: WHERE PGOA.po_header_id = POH.po_header_id
11800: AND PGOA.purchasing_org_id = POH1.org_id
11801: AND PGOA.enabled_flag = 'Y');
11802:

Line 12044: FROM PO_GA_ORG_ASSIGNMENTS pgoa

12040: WHERE pllg.po_line_id = pol.po_line_id
12041: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
12042: AND NOT EXISTS
12043: (SELECT 'Enabled vendor site'
12044: FROM PO_GA_ORG_ASSIGNMENTS pgoa
12045: WHERE PGOA.po_header_id = POH2.po_header_id
12046: AND PGOA.vendor_site_id = POH1.vendor_site_id
12047: AND PGOA.enabled_flag = 'Y');
12048:

Line 12721: FROM po_ga_org_assignments PGOA,

12717: FROM po_line_locations_gt pllg
12718: WHERE pllg.po_line_id = pol.po_line_id
12719: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
12720: AND NOT EXISTS (SELECT 1
12721: FROM po_ga_org_assignments PGOA,
12722: po_system_parameters PSP
12723: WHERE PGOA.po_header_id = POHA.po_header_id
12724: AND PGOA.purchasing_org_id = PSP.org_id
12725: AND PGOA.enabled_flag = 'Y');

Line 12797: FROM po_ga_org_assignments PGOA

12793: FROM po_line_locations_gt pllg
12794: WHERE pllg.po_line_id = pol.po_line_id
12795: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
12796: AND NOT EXISTS (SELECT 1
12797: FROM po_ga_org_assignments PGOA
12798: WHERE PGOA.po_header_id = POHA.po_header_id
12799: AND PGOA.vendor_site_id = Decode( Nvl ( poha.Enable_All_Sites,'N'),'N',POH.vendor_site_id,pgoa.Vendor_Site_Id)
12800: AND PGOA.enabled_flag = 'Y');
12801: