DBA Data[Home] [Help]

APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 58: csi_i_extended_attribs attr

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'
61: AND attrval.instance_id = cii.instance_id
62: AND attrval.attribute_id = attr.attribute_id

Line 79: csi_i_extended_attribs attr

75: SELECT acc.access_id,
76: acc.user_id
77: FROM csm_csi_item_attr_acc acc,
78: csi_iea_values attrval,
79: csi_i_extended_attribs attr
80: WHERE acc.attribute_value_id = attrval.attribute_value_id
81: AND attrval.attribute_id = attr.attribute_id
82: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
83: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)

Line 98: csi_i_extended_attribs attr

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'
101: AND attrval.instance_id = cii.instance_id
102: AND attrval.attribute_id = attr.attribute_id