DBA Data[Home] [Help]

APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 55: FROM csm_item_instances_acc ii_acc,

51: IS
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

Line 95: FROM csm_item_instances_acc ii_acc,

91: acc.user_id
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