DBA Data[Home] [Help]

APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 56: csi_item_instances cii,

52: SELECT attrval.attribute_value_id,
53: ii_acc.instance_id,
54: ii_acc.user_id
55: FROM csm_item_instances_acc ii_acc,
56: csi_item_instances cii,
57: csi_iea_values attrval,
58: csi_i_extended_attribs attr
59: WHERE ii_acc.instance_id = cii.instance_id
60: AND cii.location_type_code <> 'INVENTORY'

Line 96: csi_item_instances cii,

92: FROM csm_csi_item_attr_acc acc
93: WHERE NOT EXISTS
94: (SELECT 1
95: FROM csm_item_instances_acc ii_acc,
96: csi_item_instances cii,
97: csi_iea_values attrval,
98: csi_i_extended_attribs attr
99: WHERE ii_acc.instance_id = cii.instance_id
100: AND cii.location_type_code <> 'INVENTORY'