DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 223: from org_organization_definitions ood

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

Line 457: ,ORG_ORGANIZATION_DEFINITIONS ood

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