DBA Data[Home] [Help]

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 1195: org_organization_definitions oog

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