APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 251: FROM csi_item_instances_h ciih,

247: BEGIN
248: DEBUG('inside '|| l_api_name || 'Get PA OU context');
249: SELECT pa.ORG_ID
250: INTO l_txn_ou_context
251: FROM csi_item_instances_h ciih,
252: csi_item_instances cii,
253: csi_transactions ct,
254: pa_projects_all pa
255: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id

Line 2062: FROM csi_item_instances_h ciih1

2058: CURSOR pending_txns_cur
2059: IS
2060: SELECT ct1.transaction_id,
2061: ct1.transaction_date
2062: FROM csi_item_instances_h ciih1
2063: ,csi_transactions ct1
2064: ,csi_txn_types ctt
2065: WHERE ct1.transaction_id = ciih1.transaction_id
2066: AND ct1.transaction_type_id = ctt.transaction_type_id

Line 2074: FROM csi_item_instances_h ciih,

2070: AND ctt.source_transaction_type NOT IN ('INTERORG_TRANS_SHIPMENT',
2071: 'ISO_SHIPMENT')
2072: AND ciih1.instance_id IN (
2073: SELECT ciih.instance_id
2074: FROM csi_item_instances_h ciih,
2075: csi_transactions ct
2076: WHERE ct.transaction_id = p_asset_attrib_rec.transaction_id
2077: AND ciih.transaction_id = ct.transaction_id)
2078: AND ct1.transaction_status_code = 'PENDING' ;

Line 2206: FROM csi_item_instances_h

2202:
2203: IF p_inst_loc_rec.transaction_id is not null THEN
2204: SELECT creation_date
2205: INTO l_time_stamp
2206: FROM csi_item_instances_h
2207: WHERE transaction_id = p_inst_loc_rec.transaction_id
2208: AND instance_id = p_inst_loc_rec.instance_id;
2209: ELSE
2210: l_time_stamp := p_inst_loc_rec.transaction_date;