eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_INST_TXN_DETAILS_V

Line 1902: FROM csi_inst_txn_details_v b

1898: SELECT a.instance_id , a.transaction_id
1899: INTO l_instance_id, l_transaction_id
1900: FROM csi_item_instances_h a,
1901: ( SELECT b.transaction_id, b.instance_id
1902: FROM csi_inst_txn_details_v b
1903: WHERE b.transaction_id > l_transaction_id
1904: AND b.instance_id = l_instance_id
1905: AND b.transaction_type_id = 109
1906: AND ROWNUM = 1

Line 2667: FROM csi_inst_txn_details_v citdv,

2663: ,citdv.serial_number serial_number
2664: ,citdv.inv_material_transaction_id
2665: ,citdv.source_transaction_type
2666: ,citdv.object_version_number
2667: FROM csi_inst_txn_details_v citdv,
2668: csi_item_instances_h ciih
2669: WHERE citdv.transaction_id = ciih.transaction_id
2670: AND citdv.instance_id = ciih.instance_id
2671: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING

Line 2688: FROM csi_inst_txn_details_v citdv

2684: ,citdv.serial_number serial_number
2685: ,citdv.inv_material_transaction_id
2686: ,citdv.source_transaction_type
2687: ,citdv.object_version_number
2688: FROM csi_inst_txn_details_v citdv
2689: WHERE citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2690: AND citdv.transaction_id = p_transaction_id
2691: AND citdv.serial_number is NOT NULL
2692: --ORDER BY 1 ;

Line 2706: FROM csi_inst_txn_details_v citdv ,

2702: ,DECODE(citdv.serial_number, NULL, (NVL(ciih.new_quantity,0) -
2703: NVL(ciih.old_quantity,0)), 1) primary_units
2704: ,citdv.serial_number serial_number
2705: ,citdv.object_version_number
2706: FROM csi_inst_txn_details_v citdv ,
2707: csi_item_instances_h ciih
2708: WHERE citdv.transaction_id = c_src_transaction_id
2709: AND ciih.transaction_id = citdv.transaction_id
2710: AND ciih.instance_id = citdv.instance_id

Line 3357: FROM csi_inst_txn_details_v citdv,

3353: ,citdv.instance_usage_code
3354: ,citdv.inventory_item_id
3355: ,citdv.transaction_quantity
3356: ,citdv.source_transaction_type
3357: FROM csi_inst_txn_details_v citdv,
3358: mtl_material_transactions mmt,
3359: csi_item_instances_h ciih
3360: WHERE mmt.inventory_item_id = c_inv_item_id
3361: AND mmt.organization_id = c_inv_org_id

Line 3429: FROM csi_inst_txn_details_v citdv,

3425: ,citdv.instance_usage_code
3426: ,citdv.transaction_quantity
3427: ,citdv.source_transaction_type
3428: ,citdv.inventory_item_id
3429: FROM csi_inst_txn_details_v citdv,
3430: csi_item_instances_h ciih,
3431: mtl_material_transactions mmt
3432: WHERE mmt.inventory_item_id = c_inv_item_id
3433: AND citdv.inv_material_transaction_id = mmt.transaction_id