APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_INST_TXN_DETAILS_V

Line 238: csi_inst_txn_details_v citdv

234: SELECT ood.operating_unit
235: INTO l_txn_ou_context
236: FROM org_organization_definitions ood,
237: mtl_material_transactions mmt,
238: csi_inst_txn_details_v citdv
239: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
240: AND citdv.inv_material_transaction_id = mmt.transaction_id
241: AND mmt.organization_id = ood.organization_id
242: AND ROWNUM = 1;

Line 273: csi_inst_txn_details_v citdv,

269: DEBUG('inside '|| l_api_name || 'Receipt item into project');
270: SELECT cod.operating_unit
271: INTO l_txn_ou_context
272: FROM rcv_transactions rt,
273: csi_inst_txn_details_v citdv,
274: org_organization_definitions cod
275: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
276: AND citdv.source_transaction_type = 'PO_RECEIPT_INTO_PROJECT'
277: AND rt.transaction_id = citdv.source_dist_ref_id2

Line 346: csi_inst_txn_details_v citdv

342: SELECT msib.asset_creation_code,
343: msib.serial_number_control_code,
344: citdv.source_transaction_date
345: FROM mtl_system_items_b msib,
346: csi_inst_txn_details_v citdv
347: WHERE msib.organization_id = citdv.inv_master_organization_id
348: AND msib.inventory_item_id = citdv.inventory_item_id
349: AND citdv.transaction_id = p_csi_txn_id
350: AND citdv.instance_id = p_inst_id;

Line 500: FROM csi_inst_txn_details_v citdv,

496: SELECT citdv.instance_id,
497: citdv.inventory_item_id,
498: citdv.inv_organization_id,
499: mmt.primary_quantity
500: FROM csi_inst_txn_details_v citdv,
501: csi_i_assets cia,
502: mtl_material_transactions mmt
503: WHERE citdv.source_header_ref_id=l_wip_entity_id
504: AND cia.instance_id=citdv.instance_id