DBA Data[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on PO_GA_ORG_ASSIGNMENTS

Line 2724: FROM po_ga_org_assignments poga

2720: )
2721: OR ( Nvl (poh.global_agreement_flag, 'N') = 'Y'
2722: AND l_vendor_site_id IS NOT NULL
2723: AND EXISTS (SELECT 'vendor site id matches'
2724: FROM po_ga_org_assignments poga
2725: WHERE poh.po_header_id = poga.po_header_id
2726: AND poga.vendor_site_id =
2727: Decode(Nvl(poh.enable_all_sites, 'N'), 'N',
2728: l_vendor_site_id,

Line 2827: FROM po_ga_org_assignments poga

2823: poh.vendor_site_id))
2824: OR ( Nvl (poh.global_agreement_flag, 'N') = 'Y'
2825: AND l_vendor_site_id IS NOT NULL
2826: AND EXISTS (SELECT 'vendor site id matches'
2827: FROM po_ga_org_assignments poga
2828: WHERE poh.po_header_id = poga.po_header_id
2829: AND poga.vendor_site_id =
2830: Decode(Nvl(poh.enable_all_sites, 'N'), 'Y',
2831: poga.vendor_site_id,