DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSI_INSTANCE_STATUSES

Line 310: , csi_instance_statuses iis

306: acc.user_ID
307: --acc.INSTANCE_ID
308: FROM csm_item_instances_acc acc
309: , csi_item_instances cii
310: , csi_instance_statuses iis
311: , asg_user asg
312: WHERE cii.instance_id = acc.instance_id
313: AND cii.location_type_code = 'INVENTORY'
314: AND cii.instance_status_id = iis.instance_status_id

Line 378: , csi_instance_statuses iis

374: civ.version_label,
375: CIR.OBJECT_ID
376: FROM csm_mtl_onhand_qty_acc cqa
377: , csi_item_instances cii
378: , csi_instance_statuses iis
379: , asg_user asg
380: , csi_i_version_labels civ
381: , CSI_II_RELATIONSHIPS CIR
382: WHERE cii.inventory_item_id = cqa.inventory_item_id