APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 8582: FROM PO_GA_ORG_ASSIGNMENTS PGOA

8578: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
8579: AND NOT EXISTS
8580: --SQL Query enabled org assignments of this current purchasing org
8581: (SELECT 'Enabled purchasing org'
8582: FROM PO_GA_ORG_ASSIGNMENTS PGOA
8583: WHERE PGOA.po_header_id = POH.po_header_id
8584: AND PGOA.purchasing_org_id = POH1.org_id
8585: AND PGOA.enabled_flag = 'Y');
8586:

Line 8820: FROM PO_GA_ORG_ASSIGNMENTS pgoa

8816: WHERE pllg.po_line_id = pol.po_line_id
8817: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
8818: AND NOT EXISTS
8819: (SELECT 'Enabled vendor site'
8820: FROM PO_GA_ORG_ASSIGNMENTS pgoa
8821: WHERE PGOA.po_header_id = POH2.po_header_id
8822: AND PGOA.vendor_site_id = POH1.vendor_site_id
8823: AND PGOA.enabled_flag = 'Y');
8824:

Line 9474: FROM po_ga_org_assignments PGOA,

9470: FROM po_line_locations_gt pllg
9471: WHERE pllg.po_line_id = pol.po_line_id
9472: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
9473: AND NOT EXISTS (SELECT 1
9474: FROM po_ga_org_assignments PGOA,
9475: po_system_parameters PSP
9476: WHERE PGOA.po_header_id = POHA.po_header_id
9477: AND PGOA.purchasing_org_id = PSP.org_id
9478: AND PGOA.enabled_flag = 'Y');

Line 9547: FROM po_ga_org_assignments PGOA

9543: FROM po_line_locations_gt pllg
9544: WHERE pllg.po_line_id = pol.po_line_id
9545: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
9546: AND NOT EXISTS (SELECT 1
9547: FROM po_ga_org_assignments PGOA
9548: WHERE PGOA.po_header_id = POHA.po_header_id
9549: AND PGOA.vendor_site_id = Decode( Nvl ( poha.Enable_All_Sites,'N'),'N',POH.vendor_site_id,pgoa.Vendor_Site_Id)
9550: AND PGOA.enabled_flag = 'Y');
9551: