DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 280: FROM org_organization_definitions ood,

276: BEGIN
277: DEBUG('inside '|| l_api_name || 'Get INV OU context');
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

Line 318: org_organization_definitions cod

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
322: AND rt.organization_id = cod.organization_id;