APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_INST_TXN_DETAILS_V

Line 282: csi_inst_txn_details_v citdv

278: SELECT ood.operating_unit
279: INTO l_txn_ou_context
280: FROM org_organization_definitions ood,
281: mtl_material_transactions mmt,
282: csi_inst_txn_details_v citdv
283: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
284: AND citdv.inv_material_transaction_id = mmt.transaction_id
285: AND mmt.organization_id = ood.organization_id
286: AND ROWNUM = 1;

Line 317: csi_inst_txn_details_v citdv,

313: DEBUG('inside '|| l_api_name || 'Receipt item into project');
314: SELECT cod.operating_unit
315: INTO l_txn_ou_context
316: FROM rcv_transactions rt,
317: csi_inst_txn_details_v citdv,
318: org_organization_definitions cod
319: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
320: AND citdv.source_transaction_type = 'PO_RECEIPT_INTO_PROJECT'
321: AND rt.transaction_id = citdv.source_dist_ref_id2

Line 390: csi_inst_txn_details_v citdv

386: SELECT msib.asset_creation_code,
387: msib.serial_number_control_code,
388: citdv.source_transaction_date
389: FROM mtl_system_items_b msib,
390: csi_inst_txn_details_v citdv
391: WHERE msib.organization_id = citdv.inv_master_organization_id
392: AND msib.inventory_item_id = citdv.inventory_item_id
393: AND citdv.transaction_id = p_csi_txn_id
394: AND citdv.instance_id = p_inst_id;

Line 544: FROM csi_inst_txn_details_v citdv,

540: SELECT citdv.instance_id,
541: citdv.inventory_item_id,
542: citdv.inv_organization_id,
543: mmt.primary_quantity
544: FROM csi_inst_txn_details_v citdv,
545: csi_i_assets cia,
546: mtl_material_transactions mmt
547: WHERE citdv.source_header_ref_id=l_wip_entity_id
548: AND cia.instance_id=citdv.instance_id