APPS.PO_AUTOCREATE_DOC dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1680: FROM po_ga_org_assignments PGOA

1676: AND POH.global_agreement_flag = 'Y'
1677: /* R12 GCPA
1678: + Vendor Site validation needs to be skipped if Enable All Sites on Contracts is Set to Y. */
1679: AND EXISTS (SELECT 1
1680: FROM po_ga_org_assignments PGOA
1681: WHERE PGOA.po_header_id = POH.po_header_id
1682: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, x_supplier_site_id)
1683: AND PGOA.organization_id = l_current_org_id
1684: AND PGOA.enabled_flag = 'Y')

Line 1712: FROM po_ga_org_assignments PGOA

1708: AND POH.global_agreement_flag = 'Y'
1709: /* R12 GCPA
1710: + Vendor Site validation needs to be skipped if Enable All Sites on Contracts is Set to Y. */
1711: AND EXISTS (SELECT 1
1712: FROM po_ga_org_assignments PGOA
1713: WHERE PGOA.po_header_id = POH.po_header_id
1714: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, x_supplier_site_id)
1715: AND PGOA.organization_id = l_current_org_id
1716: AND PGOA.enabled_flag = 'Y')

Line 6939: FROM po_ga_org_assignments PGOA,

6935: and nvl(POH.closed_code,'OPEN') = 'OPEN'
6936: AND NVL(POH.frozen_flag, 'N') = 'N'
6937: AND (NVL(POH.global_agreement_flag, 'N') = 'N'
6938: OR EXISTS (SELECT 1
6939: FROM po_ga_org_assignments PGOA,
6940: po_system_parameters PSP
6941: WHERE PGOA.po_header_id = POH.po_header_id
6942: AND PGOA.organization_id = PSP.org_id
6943: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, l_vendor_site_id) -- Bug#14157987