DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 236: FROM org_organization_definitions ood,

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

Line 274: org_organization_definitions cod

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