APPS.INV_TRANSACTION_FLOW_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3287: From mtl_material_transactions mmt

3283: l_progress := 1;
3284: BEGIN
3285: select mmt.organization_id, transaction_date
3286: into l_organization_id, l_transaction_date
3287: From mtl_material_transactions mmt
3288: where mmt.transaction_id= p_reference_id;
3289: EXCEPTION
3290: WHEN NO_DATA_FOUND then
3291: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');

Line 3782: from mtl_material_transactions mmt

3778: IF l_cto_item_flag = 'Y' THEN
3779:
3780: select l.ato_line_id,l.header_id
3781: into l_ato_line_id,l_order_header_id
3782: from mtl_material_transactions mmt
3783: , oe_order_lines_all l
3784: WHERE MMT.transaction_id = p_transaction_id
3785: AND l.line_id = mmt.trx_source_line_id;
3786:

Line 3797: FROM mtl_material_transactions

3793: ELSE
3794:
3795: SELECT trx_source_line_id
3796: INTO l_order_line_id
3797: FROM mtl_material_transactions
3798: WHERE transaction_id = p_transaction_id;
3799:
3800: END IF;
3801: EXCEPTION

Line 4033: From mtl_material_transactions

4029: else
4030: BEGIN
4031: select 1
4032: INTO l_count
4033: From mtl_material_transactions
4034: WHERE transaction_id = p_transaction_id;
4035:
4036: l_transaction_id := p_transaction_id;
4037: l_order_line_id := null;

Line 4647: FROM mtl_material_transactions

4643: /* Added following logic for ISO with confgiured items calling of the CTO roll-up price API
4644: only when the price is not associated with the configured item */
4645: BEGIN
4646: SELECT transaction_source_type_id into l_trx_src_type_id
4647: FROM mtl_material_transactions
4648: WHERE transaction_id = p_transaction_id;
4649: if ( l_trx_src_type_id = 8 ) AND ( l_base_item <> 0 ) AND ( nvl(l_inv_transfer_price,0) <> 0 )
4650: AND ( l_inv_currency_code is not null ) then
4651: l_transfer_price := l_inv_transfer_price;