APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_TXN_TYPES

Line 154: FROM csi_txn_types

150: WHERE transaction_id = p_txn_id;
151:
152: SELECT source_txn_type_name
153: INTO l_txn_type
154: FROM csi_txn_types
155: WHERE transaction_type_id = l_txn_type_id;
156:
157: l_string := fill(p_txn_id, 12, 'L')||
158: fill(' ', 2)||

Line 1166: csi_txn_types ctt

1162: FROM csi_item_instances cii,
1163: csi_item_instances_h ciih,
1164: csi_transactions ct,
1165: mtl_material_transactions mmt,
1166: csi_txn_types ctt
1167: WHERE ct.transaction_id = p_transaction_id
1168: AND ct.inv_material_transaction_id = mmt.transaction_id(+)
1169: AND ct.transaction_type_id = ctt.transaction_type_id
1170: AND cii.instance_id = ciih.instance_id

Line 1539: csi_txn_types ctt

1535: ct.inv_material_transaction_id,
1536: ct.object_version_number,
1537: ctt.source_transaction_type
1538: FROM csi_transactions ct,
1539: csi_txn_types ctt
1540: WHERE ct.transaction_id = p_transaction_id
1541: AND ctt.transaction_type_id = ct.transaction_type_id;
1542:
1543: CURSOR mtl_txn_cur(p_mtl_txn_id IN number) IS

Line 3414: FROM csi_txn_types

3410: WHERE transaction_id = p_material_transaction_id;
3411:
3412: SELECT source_transaction_type
3413: INTO l_src_transaction_type
3414: FROM csi_txn_types
3415: WHERE transaction_type_id = p_transaction_type_id;
3416:
3417: ---FOR Source Non-Serial and Destination Serial
3418: FOR src_nosrl_trans_rec IN src_nosrl_trans_cur