DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSI_INSTANCE_STATUSES

Line 311: , csi_instance_statuses iis

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

Line 377: , csi_instance_statuses iis

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