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 ORG_ORGANIZATION_DEFINITIONS

Line 356: org_organization_definitions oog

352: BEGIN
353: SELECT vendor_site_id
354: INTO x_vendor_site_id
355: FROM po_vendor_sites_all pvs,
356: org_organization_definitions oog
357: WHERE pvs.vendor_site_code = l_vendor_site_code
358: AND nvl(pvs.org_id,nvl(oog.operating_unit,-1)) =
359: nvl(oog.operating_unit,-1)
360: AND oog.organization_id = x_organization_id

Line 1199: org_organization_definitions oog

1195: BEGIN
1196: SELECT vendor_site_id
1197: INTO x_vendor_site_id
1198: FROM po_vendor_sites_all pvs,
1199: org_organization_definitions oog
1200: WHERE pvs.vendor_site_code = p_vendor_site_code
1201: AND pvs.vendor_id = x_vendor_id --
1202: AND nvl(pvs.org_id,nvl(oog.operating_unit,-1)) =
1203: nvl(oog.operating_unit,-1)

Line 7053: org_organization_definitions currentorg_ou

7049: FROM po_approved_supplier_list pasl,
7050: po_asl_attributes paa,
7051: po_asl_status_rules pasr,
7052: po_vendor_sites_all pvsl,
7053: org_organization_definitions currentorg_ou
7054: WHERE pasl.item_id = p_item_id
7055: AND pasl.using_organization_id IN ( -1, p_organization_id )
7056: AND pasl.asl_id = paa.asl_id
7057: AND pasr.business_rule = '2_SOURCING'

Line 7070: FROM org_organization_definitions

7066: AND pvsl.vendor_id = pasl.vendor_id
7067: AND currentorg_ou.organization_id = p_organization_id
7068: AND pasl.vendor_site_id = pvsl.vendor_site_id
7069: AND currentorg_ou.operating_unit = (SELECT operating_unit
7070: FROM org_organization_definitions
7071: WHERE organization_id = pvsl.org_id);
7072:
7073:
7074: EXCEPTION