DBA Data[Home] [Help]

APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1526: csi_item_instances c

1522: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1523: , c.instance_id
1524: FROM csi_i_extended_attribs a,
1525: csi_t_txn_line_details b,
1526: csi_item_instances c
1527: WHERE a.attribute_level = 'INSTANCE'
1528: AND a.attribute_code = c_attribute_code
1529: AND b.config_inst_hdr_id IS NOT NULL
1530: AND b.config_inst_hdr_id = c.config_inst_hdr_id

Line 1567: csi_item_instances b

1563: AND config_inst_hdr_id IS NULL
1564: UNION
1565: SELECT b.instance_id
1566: FROM csi_t_txn_line_details a,
1567: csi_item_instances b
1568: WHERE a.txn_line_detail_id = p_txn_line_detail_id
1569: AND a.config_inst_hdr_id IS NOT NULL
1570: AND a.config_inst_hdr_id = b.config_inst_hdr_id
1571: AND a.config_inst_rev_num = b.config_inst_rev_num