DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on MTL_ITEM_CATEGORIES

Line 631: mtl_item_categories mic

627: set process_status = 'E'
628: Where (cuh.inventory_item_id,cuh.organization_id,cuh.secondary_inventory) in
629: (select mic.inventory_item_id,mic.organization_id,nvl(cpp.secondary_inventory,'-')
630: from csp_planning_parameters cpp,
631: mtl_item_categories mic
632: where cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY')
633: and mic.organization_id = cpp.organization_id
634: and mic.category_set_id = cpp.category_set_id
635: and mic.category_id = nvl(cpp.category_id,mic.category_id));