APPS.CSE_FA_TXN_PKG dependencies on CSI_ITEM_INSTANCES

Line 67: FROM csi_item_instances

63:
64: debug(' Instance ID : '||l_u_instance_rec.instance_id);
65: SELECT object_version_number, serial_number, quantity, active_end_date
66: INTO l_u_instance_rec.object_version_number, l_serial_number, l_instance_qty, l_instance_end_date
67: FROM csi_item_instances
68: WHERE instance_id = l_u_instance_rec.instance_id;
69:
70: debug(' Serial Number : '||l_serial_number);
71: debug(' Quantity : '||l_instance_qty);

Line 77: FROM csi_item_instances_h cih, csi_transactions ct

73:
74: BEGIN
75: SELECT old_inst_usage_code
76: INTO l_h_instance_usage_code
77: FROM csi_item_instances_h cih, csi_transactions ct
78: WHERE cih.instance_id = l_u_instance_rec.instance_id
79: AND cih.transaction_id = ct.transaction_id
80: AND ct.TRANSACTION_TYPE_ID = 104
81: AND old_inst_usage_code IS NOT NULL

Line 94: FROM csi_item_instances_h cih, csi_transactions ct

90:
91: BEGIN
92: SELECT old_instance_status_id
93: INTO l_h_Instance_status_id
94: FROM csi_item_instances_h cih, csi_transactions ct
95: WHERE cih.instance_id = l_u_instance_rec.instance_id
96: AND cih.transaction_id = ct.transaction_id
97: AND ct.TRANSACTION_TYPE_ID = 104
98: AND old_instance_status_id IS NOT NULL

Line 359: csi_item_instances_h ciih,

355: RAISE fnd_api.g_exc_error;
356: END IF;
357: /* SELECT citdv.instance_id,citdv.*
358: FROM csi_i_assets_h ciah,
359: csi_item_instances_h ciih,
360: csi_transactions ct
361: WHERE ciah.transaction_id = ciih.transaction_id
362: AND citdv.transaction_type_id = 104
363: AND ciah.instance_asset_id = 75478