APPS.PO_AUTOCREATE_DOC dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1463: FROM po_ga_org_assignments PGOA

1459: AND POH.global_agreement_flag = 'Y'
1460: /* R12 GCPA
1461: + Vendor Site validation needs to be skipped if Enable All Sites on Contracts is Set to Y. */
1462: AND EXISTS (SELECT 1
1463: FROM po_ga_org_assignments PGOA
1464: WHERE PGOA.po_header_id = POH.po_header_id
1465: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, x_supplier_site_id)
1466: AND PGOA.organization_id = l_current_org_id
1467: AND PGOA.enabled_flag = 'Y')

Line 1495: FROM po_ga_org_assignments PGOA

1491: AND POH.global_agreement_flag = 'Y'
1492: /* R12 GCPA
1493: + Vendor Site validation needs to be skipped if Enable All Sites on Contracts is Set to Y. */
1494: AND EXISTS (SELECT 1
1495: FROM po_ga_org_assignments PGOA
1496: WHERE PGOA.po_header_id = POH.po_header_id
1497: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, x_supplier_site_id)
1498: AND PGOA.organization_id = l_current_org_id
1499: AND PGOA.enabled_flag = 'Y')

Line 6487: FROM po_ga_org_assignments PGOA,

6483: and nvl(POH.closed_code,'OPEN') = 'OPEN'
6484: AND NVL(POH.frozen_flag, 'N') = 'N'
6485: AND (NVL(POH.global_agreement_flag, 'N') = 'N'
6486: OR EXISTS (SELECT 1
6487: FROM po_ga_org_assignments PGOA,
6488: po_system_parameters PSP
6489: WHERE PGOA.po_header_id = POH.po_header_id
6490: AND PGOA.organization_id = PSP.org_id
6491: AND PGOA.vendor_site_id = l_vendor_site_id