APPS.CST_UTILITY_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 727: from mtl_material_transactions mmt, fnd_currencies fc

723: P_USER_ID,
724: sysdate,
725: P_USER_ID,
726: P_LOGIN_ID
727: from mtl_material_transactions mmt, fnd_currencies fc
728: where mmt.transaction_id = P_TXN_ID
729: and (mmt.organization_id = P_ORG_ID or
730: mmt.transfer_organization_id = P_ORG_ID)
731: and fc.currency_code = nvl(mmt.currency_code, l_pri_curr);

Line 966: from mtl_material_transactions mmt

962: l_wip_entity_id,
963: l_item_id,
964: l_sub_inventory,
965: l_org_id
966: from mtl_material_transactions mmt
967: where mmt.transaction_id = p_txn_id;
968: exception
969: when no_data_found then
970: l_api_message := 'Transaction ID does not exist in MTL_MATERIAL_TRANSACTIONS table. ';

Line 970: l_api_message := 'Transaction ID does not exist in MTL_MATERIAL_TRANSACTIONS table. ';

966: from mtl_material_transactions mmt
967: where mmt.transaction_id = p_txn_id;
968: exception
969: when no_data_found then
970: l_api_message := 'Transaction ID does not exist in MTL_MATERIAL_TRANSACTIONS table. ';
971: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
972: FND_MESSAGE.set_token('TEXT', l_api_message);
973: FND_MSG_PUB.add;
974: RAISE fnd_api.g_exc_error;