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 1670: FROM po_ga_org_assignments poga,

1666: AND ( p_vendor_site_sourcing_flag = 'Y'
1667: AND (p_vendor_site_code IS NULL OR
1668: EXISTS (
1669: SELECT 'vendor site code matches'
1670: FROM po_ga_org_assignments poga,
1671: po_vendor_sites_all pvsa
1672: WHERE poh.po_header_id = poga.po_header_id
1673: AND poga.organization_id = p_org_id
1674: 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 1683: FROM po_ga_org_assignments poga

1679: )OR ( p_vendor_site_sourcing_flag = 'N'
1680: --
1681: AND EXISTS (
1682: SELECT 'vendor site id matches'
1683: FROM po_ga_org_assignments poga
1684: WHERE poh.po_header_id = poga.po_header_id
1685: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
1686: AND poga.enabled_flag = 'Y')
1687: AND (x_destination_doc_type = 'STANDARD PO'

Line 1690: FROM po_ga_org_assignments poga

1686: AND poga.enabled_flag = 'Y')
1687: AND (x_destination_doc_type = 'STANDARD PO'
1688: OR EXISTS (
1689: SELECT 'enabled org exists'
1690: FROM po_ga_org_assignments poga
1691: WHERE poh.po_header_id = poga.po_header_id
1692: AND poga.organization_id = p_org_id
1693: AND poga.enabled_flag = 'Y'))
1694: --

Line 1796: FROM po_ga_org_assignments poga

1792: x_vendor_site_id is null
1793: OR
1794: EXISTS (
1795: SELECT 'vendor site id matches'
1796: FROM po_ga_org_assignments poga
1797: WHERE poh.po_header_id = poga.po_header_id
1798: AND poga.vendor_site_id = x_vendor_site_id
1799: AND poga.enabled_flag = 'Y')
1800: )

Line 2650: FROM po_ga_org_assignments poga,

2646: OR ( NVL (poh.global_agreement_flag, 'N') = 'Y'
2647: AND ( ( p_vendor_site_sourcing_flag = 'Y'
2648: AND EXISTS (
2649: SELECT 'vendor site code matches'
2650: FROM po_ga_org_assignments poga,
2651: po_vendor_sites_all pvsa
2652: WHERE poh.po_header_id = poga.po_header_id
2653: AND poga.organization_id = p_org_id
2654: AND poga.vendor_site_id = pvsa.vendor_site_id

Line 2668: FROM po_ga_org_assignments poga

2664: x_vendor_site_id is null
2665: OR
2666: EXISTS (
2667: SELECT 'vendor site id matches'
2668: FROM po_ga_org_assignments poga
2669: WHERE poh.po_header_id = poga.po_header_id
2670: AND poga.vendor_site_id = x_vendor_site_id
2671: AND poga.enabled_flag = 'Y')
2672: )

Line 2676: FROM po_ga_org_assignments poga

2672: )
2673: AND (x_destination_doc_type = 'STANDARD PO'
2674: OR EXISTS (
2675: SELECT 'enabled org exists'
2676: FROM po_ga_org_assignments poga
2677: WHERE poh.po_header_id = poga.po_header_id
2678: AND poga.organization_id = p_org_id
2679: AND poga.enabled_flag = 'Y'))
2680: --

Line 2762: FROM po_ga_org_assignments poga,

2758: AND ( ( p_vendor_site_sourcing_flag = 'Y'
2759: AND (p_vendor_site_code IS NULL OR
2760: EXISTS (
2761: SELECT 'vendor site code matches'
2762: FROM po_ga_org_assignments poga,
2763: po_vendor_sites_all pvsa
2764: WHERE poh.po_header_id = poga.po_header_id
2765: AND poga.organization_id = p_org_id
2766: 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 2780: FROM po_ga_org_assignments poga

2776: x_vendor_site_id is null
2777: OR
2778: EXISTS (
2779: SELECT 'vendor site id matches'
2780: FROM po_ga_org_assignments poga
2781: WHERE poh.po_header_id = poga.po_header_id
2782: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2783: AND poga.enabled_flag = 'Y')
2784: )

Line 2788: FROM po_ga_org_assignments poga

2784: )
2785: AND (x_destination_doc_type = 'STANDARD PO'
2786: OR EXISTS (
2787: SELECT 'enabled org exists'
2788: FROM po_ga_org_assignments poga
2789: WHERE poh.po_header_id = poga.po_header_id
2790: AND poga.organization_id = p_org_id
2791: AND poga.enabled_flag = 'Y'))
2792: --

Line 2896: FROM po_ga_org_assignments poga

2892: x_vendor_site_id is null
2893: OR
2894: EXISTS (
2895: SELECT 'vendor site id matches'
2896: FROM po_ga_org_assignments poga
2897: WHERE poh.po_header_id = poga.po_header_id
2898: AND poga.vendor_site_id = decode( Nvl (poh.Enable_All_Sites,'N'),'Y',poga.Vendor_Site_Id,x_vendor_site_id) --< R12 GCPA ER>
2899: AND poga.enabled_flag = 'Y')
2900: )

Line 3930: FROM po_ga_org_assignments poga,

3926: )
3927: AND ( NVL (poh.global_agreement_flag, 'N') = 'Y'
3928: AND EXISTS (
3929: SELECT 'vendor site code matches GA'
3930: FROM po_ga_org_assignments poga,
3931: po_vendor_sites_all pvs
3932: WHERE poh.po_header_id = poga.po_header_id
3933: AND poga.organization_id = p_org_id
3934: AND poga.enabled_flag = 'Y'

Line 4303: FROM po_ga_org_assignments poga,

4299: )
4300: AND ( NVL (poh.global_agreement_flag, 'N') = 'Y'
4301: AND EXISTS (
4302: SELECT 'vendor site code matches GA'
4303: FROM po_ga_org_assignments poga,
4304: po_vendor_sites_all pvs
4305: WHERE poh.po_header_id = poga.po_header_id
4306: AND poga.organization_id = p_org_id
4307: AND poga.enabled_flag = 'Y'

Line 5987: from po_ga_org_assignments poga,

5983: --
5984: AND ( (poh.type_lookup_code = 'CONTRACT'
5985: AND nvl(poh.global_agreement_flag,'N') = 'N') -- Bug 3262136
5986: OR exists (select 'site in POU'
5987: from po_ga_org_assignments poga,
5988: po_vendor_sites_all povs
5989: where poh.po_header_id = poga.po_header_id
5990: and povs.vendor_site_id = l_vendor_site_id
5991: and povs.org_id = poga.purchasing_org_id

Line 6021: FROM po_ga_org_assignments poga

6017: AND ( (poh.type_lookup_code = 'CONTRACT'
6018: AND nvl(poh.global_agreement_flag,'N') = 'N') OR -- Bug 3262136
6019: (nvl(poh.global_agreement_flag,'N') = 'Y'
6020: AND EXISTS (SELECT 'enabled orgs'
6021: FROM po_ga_org_assignments poga
6022: WHERE poh.po_header_id = poga.po_header_id
6023: AND poga.organization_id = l_org_id
6024: AND poga.enabled_flag = 'Y'
6025: ) )

Line 6067: FROM po_ga_org_assignments poga,

6063: AND povs.org_id = l_org_id)
6064: )
6065: OR
6066: EXISTS (SELECT 'site in POU'
6067: FROM po_ga_org_assignments poga,
6068: po_vendor_sites_all povs
6069: WHERE poh.po_header_id = poga.po_header_id
6070: AND povs.vendor_site_id = l_vendor_site_id
6071: AND povs.org_id = poga.purchasing_org_id

Line 6113: FROM po_ga_org_assignments poga

6109: AND ( (poh.type_lookup_code = 'CONTRACT'
6110: AND nvl(poh.global_agreement_flag,'N') = 'N') OR -- Bug 3262136
6111: (nvl(poh.global_agreement_flag,'N') = 'Y'
6112: AND EXISTS (SELECT 'enabled orgs'
6113: FROM po_ga_org_assignments poga
6114: WHERE poh.po_header_id = poga.po_header_id
6115: AND poga.organization_id = l_org_id
6116: AND poga.enabled_flag = 'Y'
6117: ) )