DBA Data[Home] [Help]

APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSI_INSTANCE_STATUSES

Line 1455: , csi_instance_statuses iis

1451: SELECT cii.instance_id,
1452: cqa.user_id
1453: FROM csm_mtl_onhand_qty_acc cqa
1454: , csi_item_instances cii
1455: , csi_instance_statuses iis
1456: , asg_user asg
1457: WHERE cqa.inventory_item_id=p_item_id
1458: AND cqa.organization_id=p_org_id
1459: AND nvl(cqa.subinventory_code,'-999') = nvl(p_subinv_code,'-999')