eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOSOURCE_SV dependencies on PO_GA_ORG_ASSIGNMENTS

Line 1660: FROM po_ga_org_assignments poga,

1656: AND ( p_vendor_site_sourcing_flag = 'Y'
1657: AND (p_vendor_site_code IS NULL OR
1658: EXISTS (
1659: SELECT 'vendor site code matches'
1660: FROM po_ga_org_assignments poga,
1661: po_vendor_sites_all pvsa
1662: WHERE poh.po_header_id = poga.po_header_id
1663: AND poga.organization_id = p_org_id
1664: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'N', pvsa.vendor_site_id ,poga.Vendor_Site_Id) -- pvsa.vendor_site_id

Line 1673: FROM po_ga_org_assignments poga

1669: )OR ( p_vendor_site_sourcing_flag = 'N'
1670: --
1671: AND EXISTS (
1672: SELECT 'vendor site id matches'
1673: FROM po_ga_org_assignments poga
1674: WHERE poh.po_header_id = poga.po_header_id
1675: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
1676: AND poga.enabled_flag = 'Y')
1677: AND (x_destination_doc_type = 'STANDARD PO'

Line 1680: FROM po_ga_org_assignments poga

1676: AND poga.enabled_flag = 'Y')
1677: AND (x_destination_doc_type = 'STANDARD PO'
1678: OR EXISTS (
1679: SELECT 'enabled org exists'
1680: FROM po_ga_org_assignments poga
1681: WHERE poh.po_header_id = poga.po_header_id
1682: AND poga.organization_id = p_org_id
1683: AND poga.enabled_flag = 'Y'))
1684: --

Line 1783: FROM po_ga_org_assignments poga

1779: x_vendor_site_id is null
1780: OR
1781: EXISTS (
1782: SELECT 'vendor site id matches'
1783: FROM po_ga_org_assignments poga
1784: WHERE poh.po_header_id = poga.po_header_id
1785: AND poga.vendor_site_id = x_vendor_site_id
1786: AND poga.enabled_flag = 'Y')
1787: )

Line 2631: FROM po_ga_org_assignments poga,

2627: OR ( NVL (poh.global_agreement_flag, 'N') = 'Y'
2628: AND ( ( p_vendor_site_sourcing_flag = 'Y'
2629: AND EXISTS (
2630: SELECT 'vendor site code matches'
2631: FROM po_ga_org_assignments poga,
2632: po_vendor_sites_all pvsa
2633: WHERE poh.po_header_id = poga.po_header_id
2634: AND poga.organization_id = p_org_id
2635: AND poga.vendor_site_id = pvsa.vendor_site_id

Line 2649: FROM po_ga_org_assignments poga

2645: x_vendor_site_id is null
2646: OR
2647: EXISTS (
2648: SELECT 'vendor site id matches'
2649: FROM po_ga_org_assignments poga
2650: WHERE poh.po_header_id = poga.po_header_id
2651: AND poga.vendor_site_id = x_vendor_site_id
2652: AND poga.enabled_flag = 'Y')
2653: )

Line 2657: FROM po_ga_org_assignments poga

2653: )
2654: AND (x_destination_doc_type = 'STANDARD PO'
2655: OR EXISTS (
2656: SELECT 'enabled org exists'
2657: FROM po_ga_org_assignments poga
2658: WHERE poh.po_header_id = poga.po_header_id
2659: AND poga.organization_id = p_org_id
2660: AND poga.enabled_flag = 'Y'))
2661: --

Line 2741: FROM po_ga_org_assignments poga,

2737: AND ( ( p_vendor_site_sourcing_flag = 'Y'
2738: AND (p_vendor_site_code IS NULL OR
2739: EXISTS (
2740: SELECT 'vendor site code matches'
2741: FROM po_ga_org_assignments poga,
2742: po_vendor_sites_all pvsa
2743: WHERE poh.po_header_id = poga.po_header_id
2744: AND poga.organization_id = p_org_id
2745: AND poga.vendor_site_id = Decode( Nvl (poh.Enable_All_Sites,'N'),'N',pvsa.vendor_site_id,poga.Vendor_Site_Id) -- pvsa.vendor_site_id

Line 2759: FROM po_ga_org_assignments poga

2755: x_vendor_site_id is null
2756: OR
2757: EXISTS (
2758: SELECT 'vendor site id matches'
2759: FROM po_ga_org_assignments poga
2760: WHERE poh.po_header_id = poga.po_header_id
2761: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2762: AND poga.enabled_flag = 'Y')
2763: )

Line 2767: FROM po_ga_org_assignments poga

2763: )
2764: AND (x_destination_doc_type = 'STANDARD PO'
2765: OR EXISTS (
2766: SELECT 'enabled org exists'
2767: FROM po_ga_org_assignments poga
2768: WHERE poh.po_header_id = poga.po_header_id
2769: AND poga.organization_id = p_org_id
2770: AND poga.enabled_flag = 'Y'))
2771: --

Line 2873: FROM po_ga_org_assignments poga

2869: x_vendor_site_id is null
2870: OR
2871: EXISTS (
2872: SELECT 'vendor site id matches'
2873: FROM po_ga_org_assignments poga
2874: WHERE poh.po_header_id = poga.po_header_id
2875: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2876: AND poga.enabled_flag = 'Y')
2877: )

Line 3902: FROM po_ga_org_assignments poga,

3898: )
3899: AND ( NVL (poh.global_agreement_flag, 'N') = 'Y'
3900: AND EXISTS (
3901: SELECT 'vendor site code matches GA'
3902: FROM po_ga_org_assignments poga,
3903: po_vendor_sites_all pvs
3904: WHERE poh.po_header_id = poga.po_header_id
3905: AND poga.organization_id = p_org_id
3906: AND poga.enabled_flag = 'Y'

Line 4275: FROM po_ga_org_assignments poga,

4271: )
4272: AND ( NVL (poh.global_agreement_flag, 'N') = 'Y'
4273: AND EXISTS (
4274: SELECT 'vendor site code matches GA'
4275: FROM po_ga_org_assignments poga,
4276: po_vendor_sites_all pvs
4277: WHERE poh.po_header_id = poga.po_header_id
4278: AND poga.organization_id = p_org_id
4279: AND poga.enabled_flag = 'Y'

Line 5910: from po_ga_org_assignments poga,

5906: --
5907: AND ( (poh.type_lookup_code = 'CONTRACT'
5908: AND nvl(poh.global_agreement_flag,'N') = 'N') -- Bug 3262136
5909: OR exists (select 'site in POU'
5910: from po_ga_org_assignments poga,
5911: po_vendor_sites_all povs
5912: where poh.po_header_id = poga.po_header_id
5913: and povs.vendor_site_id = l_vendor_site_id
5914: and povs.org_id = poga.purchasing_org_id

Line 5944: FROM po_ga_org_assignments poga

5940: AND ( (poh.type_lookup_code = 'CONTRACT'
5941: AND nvl(poh.global_agreement_flag,'N') = 'N') OR -- Bug 3262136
5942: (nvl(poh.global_agreement_flag,'N') = 'Y'
5943: AND EXISTS (SELECT 'enabled orgs'
5944: FROM po_ga_org_assignments poga
5945: WHERE poh.po_header_id = poga.po_header_id
5946: AND poga.organization_id = l_org_id
5947: AND poga.enabled_flag = 'Y'
5948: ) )

Line 5990: FROM po_ga_org_assignments poga,

5986: AND povs.org_id = l_org_id)
5987: )
5988: OR
5989: EXISTS (SELECT 'site in POU'
5990: FROM po_ga_org_assignments poga,
5991: po_vendor_sites_all povs
5992: WHERE poh.po_header_id = poga.po_header_id
5993: AND povs.vendor_site_id = l_vendor_site_id
5994: AND povs.org_id = poga.purchasing_org_id

Line 6036: FROM po_ga_org_assignments poga

6032: AND ( (poh.type_lookup_code = 'CONTRACT'
6033: AND nvl(poh.global_agreement_flag,'N') = 'N') OR -- Bug 3262136
6034: (nvl(poh.global_agreement_flag,'N') = 'Y'
6035: AND EXISTS (SELECT 'enabled orgs'
6036: FROM po_ga_org_assignments poga
6037: WHERE poh.po_header_id = poga.po_header_id
6038: AND poga.organization_id = l_org_id
6039: AND poga.enabled_flag = 'Y'
6040: ) )