APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 1094: ' from csi_t_txn_line_details'||

1090: ' attribute14, attribute15, object_version_number '||
1091: 'from csi_i_extended_attribs '||
1092: 'where (inventory_item_id, master_organization_id) in '||
1093: ' (select inventory_item_id,inv_organization_id '||
1094: ' from csi_t_txn_line_details'||
1095: ' where txn_line_detail_id = :line_dtl_id '||
1096: ' and instance_exists_flag = ''N'') ';
1097:
1098: l_inst_based_stmt :=

Line 1495: csi_t_txn_line_details b,

1491: CURSOR get_item_attrib_cur (c_attribute_code IN VARCHAR2)
1492: IS
1493: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1494: FROM csi_i_extended_attribs a ,
1495: csi_t_txn_line_details b,
1496: mtl_parameters mtp -- Added for bug 4118180
1497: WHERE a.attribute_level = 'ITEM'
1498: AND a.attribute_code = c_attribute_code
1499: AND a.inventory_item_id = b.inventory_item_id

Line 1512: csi_t_txn_line_details b

1508: --FOR non-CZ
1509: SELECT a.attribute_id, b.inventory_item_id, b.inv_organization_id
1510: , a.instance_id
1511: FROM csi_i_extended_attribs a,
1512: csi_t_txn_line_details b
1513: WHERE a.attribute_level = 'INSTANCE'
1514: AND a.attribute_code = c_attribute_code
1515: AND b.config_inst_hdr_id IS NULL
1516: AND b.txn_line_detail_id = p_txn_line_detail_id

Line 1525: csi_t_txn_line_details b,

1521: ---FOR CZ
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

Line 1545: csi_t_txn_line_details ctld

1541: FROM mtl_item_categories mti,
1542: mtl_categories_b mtc ,
1543: --csi_install_parameters csii,
1544: csi_i_extended_attribs csie ,
1545: csi_t_txn_line_details ctld
1546: WHERE mti.organization_id = ctld.inv_organization_id -- Bug 4306650. Typo:inv_orgn and item_id swap
1547: AND mti.inventory_item_id = ctld.inventory_item_id -- Bug 4306650. Typo:inv_orgn and item_id swap
1548: AND mti.category_set_id = c_category_set_id -- csii.category_set_id
1549: AND mti.category_id = mtc.category_id

Line 1561: FROM csi_t_txn_line_details

1557:
1558: CURSOR instance_id_cur
1559: IS
1560: SELECT instance_id
1561: FROM csi_t_txn_line_details
1562: WHERE txn_line_detail_id = p_txn_line_detail_id
1563: AND config_inst_hdr_id IS NULL
1564: UNION
1565: SELECT b.instance_id

Line 1566: FROM csi_t_txn_line_details a,

1562: WHERE txn_line_detail_id = p_txn_line_detail_id
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