DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 224: from org_organization_definitions ood

220: Begin
221:
222: select ood.organization_code
223: into l_organization_code
224: from org_organization_definitions ood
225: where sysdate < nvl(ood.disable_date,sysdate+1)
226: and ood.organization_id = p_organization_id ;
227:
228: Return l_organization_code;

Line 458: ,ORG_ORGANIZATION_DEFINITIONS ood

454: SELECT pv.vendor_name
455: INTO l_vendor_name
456: FROM PO_VENDORS pv
457: ,PO_VENDOR_SITES_ALL pvsa
458: ,ORG_ORGANIZATION_DEFINITIONS ood
459: WHERE ood.ORGANIZATION_ID = p_org_id
460: AND nvl(pvsa.ORG_ID,-99) = nvl(ood.OPERATING_UNIT,-99)
461: AND pvsa.PURCHASING_SITE_FLAG = 'Y'
462: AND sysdate < nvl(pvsa.INACTIVE_DATE, sysdate + 1)