eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPINV dependencies on MTL_MATERIAL_TRANSACTIONS

Line 125: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT

121: l_stmt_num := 50;
122: IF (i_txn_action_id in( 21,22)) THEN -- INVCONV sikhanna
123: SELECT nvl(MMT.fob_point, MIP.fob_point)
124: INTO l_fob_point
125: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT
126: WHERE MIP.from_organization_id = i_txn_org_id
127: AND MIP.to_organization_id = i_txfr_org_id
128: AND MMT.transaction_id = i_txn_id;
129: ELSIF (i_txn_action_id in (12,15)) THEN

Line 132: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT

128: AND MMT.transaction_id = i_txn_id;
129: ELSIF (i_txn_action_id in (12,15)) THEN
130: SELECT nvl(MMT.fob_point, MIP.fob_point)
131: INTO l_fob_point
132: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT
133: WHERE MIP.from_organization_id = i_txfr_org_id
134: AND MIP.to_organization_id = i_txn_org_id
135: AND MMT.transaction_id = i_txn_id;
136: ELSE

Line 168: UPDATE mtl_material_transactions

164: /* Bug 6751847 fix to prevent update from both shipping as well as
165: receiving cost groups,to avoid lock and hold when run in
166: parallel for multiple Cost Groups */
167:
168: UPDATE mtl_material_transactions
169: SET periodic_primary_quantity = l_converted_txn_qty
170: WHERE transaction_id = i_txn_id
171: AND organization_id = i_txn_org_id
172: AND EXISTS ( SELECT 'x'

Line 219: from mtl_material_transactions mmt

215:
216: IF (i_txn_action_id = 6) then
217:
218: Select mmt.transaction_cost into l_txn_cost
219: from mtl_material_transactions mmt
220: where mmt.transaction_id = i_txn_id ;
221:
222: ELSE
223:

Line 231: from rcv_transactions rt, mtl_material_transactions mmt

227: -- they come in at PO price
228:
229: select nvl(rt.dropship_type_code, 3), mmt.transaction_cost, rt.parent_transaction_id
230: into l_dropship_type_code, l_txn_cost, l_parent_rcv_txn_id
231: from rcv_transactions rt, mtl_material_transactions mmt
232: where mmt.transaction_id = i_txn_id
233: and mmt.rcv_transaction_id = rt.transaction_id;
234:
235: END IF; /* end of check for consigned txfrs */

Line 336: FROM mtl_material_transactions MMT,

332: -- will return the line ID of that sales order. Else NULL
333: l_stmt_num := 74;
334: SELECT RMA.reference_line_id
335: INTO l_so_line_id
336: FROM mtl_material_transactions MMT,
337: oe_order_lines_all RMA
338: WHERE MMT.transaction_id = i_txn_id
339: AND RMA.line_id = MMT.trx_source_line_id;
340:

Line 401: FROM mtl_material_transactions MMT,

397: i_prog_appl_id,
398: i_prog_id,
399: SYSDATE,
400: i_login_id
401: FROM mtl_material_transactions MMT,
402: mtl_pac_actual_cost_details MPACD
403: WHERE MMT.transaction_action_id = 1
404: AND MMT.transaction_source_type_id = 2
405: AND MMT.organization_id = i_txn_org_id

Line 453: FROM mtl_material_transactions MMT,

449: i_prog_appl_id,
450: i_prog_id,
451: SYSDATE,
452: i_login_id
453: FROM mtl_material_transactions MMT,
454: mtl_cst_actual_cost_details MCACD
455: WHERE MMT.transaction_action_id = 1
456: AND MMT.transaction_source_type_id = 2
457: AND MMT.organization_id = i_txn_org_id

Line 749: FROM mtl_material_transactions

745: INTO l_shipment_txn_id,
746: l_txn_src_type_id,
747: /*l_txn_id,*/
748: l_trp_cost -- INVCONV
749: FROM mtl_material_transactions
750: WHERE transaction_id = i_txn_id;
751:
752: IF l_debug = 'Y' THEN
753: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

Line 765: FROM mtl_material_transactions mmt,

761:
762: /* Get FOB Point */
763: SELECT nvl(mmt.fob_point,mip.fob_point)
764: INTO l_fob_point
765: FROM mtl_material_transactions mmt,
766: mtl_interorg_parameters mip
767: WHERE mmt.transaction_id = i_txn_id
768: AND mip.from_organization_id = l_from_org
769: AND mip.to_organization_id = l_to_org;

Line 838: FROM mtl_material_transactions

834:
835: /* Get transfer price from MMT */
836: SELECT transfer_price
837: INTO l_txfr_price
838: FROM mtl_material_transactions
839: WHERE transaction_id = l_shipment_txn_id;
840:
841: IF (l_txfr_price is NULL) THEN
842: fnd_file.put_line(fnd_file.log,'Transfer Price not available');

Line 1395: FROM mtl_material_transactions

1391: INTO l_txfr_percent,
1392: l_txfr_cost,
1393: l_trp_cost,
1394: l_shipment_txn_qty
1395: FROM mtl_material_transactions
1396: WHERE transaction_id = i_source_txn_id;
1397:
1398: IF l_debug = 'Y' THEN
1399: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

Line 2035: FROM mtl_material_transactions

2031: l_stmt_num := 10;
2032:
2033: SELECT primary_quantity
2034: INTO l_mta_txn_qty
2035: FROM mtl_material_transactions
2036: WHERE transaction_id = i_mta_txn_id;
2037:
2038: IF l_debug = 'Y' THEN
2039: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_mta_txn_qty = ' || l_mta_txn_qty);

Line 2217: FROM mtl_material_transactions

2213: l_stmt_num := 50;
2214:
2215: SELECT currency_conversion_type, TRUNC(transaction_date)
2216: INTO l_curr_type, l_txn_date
2217: FROM mtl_material_transactions
2218: WHERE transaction_id = i_txn_id;
2219:
2220: if (l_curr_type is NULL) then
2221: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_type);

Line 2398: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;

2394: l_parent_transaction_id NUMBER := -1;
2395: l_logical_transaction NUMBER := 3;
2396: l_parent_organization_id NUMBER := -1;
2397: l_um_rate NUMBER := 1;
2398: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2399: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2400: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2401: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2402: l_converted_txn_qty NUMBER;

Line 2399: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;

2395: l_logical_transaction NUMBER := 3;
2396: l_parent_organization_id NUMBER := -1;
2397: l_um_rate NUMBER := 1;
2398: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2399: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2400: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2401: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2402: l_converted_txn_qty NUMBER;
2403: l_stmt_num NUMBER;

Line 2426: from mtl_material_transactions

2422: transaction_action_id
2423: into l_parent_transaction_id,
2424: l_txn_src_type_id,
2425: l_txn_action_id
2426: from mtl_material_transactions
2427: where transaction_id = i_txn_id;
2428:
2429: if (l_parent_transaction_id <> -1 ) then
2430:

Line 2435: from mtl_material_transactions

2431: select organization_id,
2432: nvl(logical_transaction, 3)
2433: into l_parent_organization_id,
2434: l_logical_transaction
2435: from mtl_material_transactions
2436: where transaction_id = l_parent_transaction_id;
2437:
2438: end if;
2439:

Line 2454: UPDATE mtl_material_transactions

2450: /* Bug 6751847 fix: to prevent execution twice from both
2451: shipping and receiving cost groups,to avoid lock when run in
2452: parallel for multiple CGs */
2453:
2454: UPDATE mtl_material_transactions
2455: SET periodic_primary_quantity = (select mmt2.periodic_primary_quantity
2456: from mtl_material_transactions mmt2
2457: where mmt2.transaction_id =
2458: l_parent_transaction_id)

Line 2456: from mtl_material_transactions mmt2

2452: parallel for multiple CGs */
2453:
2454: UPDATE mtl_material_transactions
2455: SET periodic_primary_quantity = (select mmt2.periodic_primary_quantity
2456: from mtl_material_transactions mmt2
2457: where mmt2.transaction_id =
2458: l_parent_transaction_id)
2459: WHERE transaction_id = i_txn_id
2460: AND organization_id = i_txn_org_id

Line 2546: UPDATE mtl_material_transactions

2542: /* Update mmt with quantity in the master org um */
2543: /* BUG 6751847 fix: to prevent execution twice
2544: for both shipping and receiving cost group, to avoid
2545: lock when run in parallel for CGs */
2546: UPDATE mtl_material_transactions
2547: SET periodic_primary_quantity = i_txn_qty
2548: WHERE transaction_id = i_txn_id
2549: AND organization_id = i_txn_org_id
2550: AND EXISTS (SELECT 'x'

Line 2850: mtl_material_transactions mmt,

2846: nvl(mmt.transfer_organization_id,-1),
2847: mmt.subinventory_code,
2848: nvl(mmt.transfer_price,0) -- INVCONV
2849: FROM
2850: mtl_material_transactions mmt,
2851: mtl_parameters mp --INVCONV sikhanna changes
2852: WHERE
2853: transaction_date between l_start_date AND l_end_date
2854: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3220: mtl_material_transactions mmt,

3216: nvl(mmt.transfer_organization_id,-1),
3217: mmt.subinventory_code,
3218: nvl(mmt.transfer_price,0) -- INVCONV
3219: FROM
3220: mtl_material_transactions mmt,
3221: mtl_parameters mp -- INCONV sikhanna
3222: WHERE
3223: transaction_date between l_start_date AND l_end_date
3224: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3622: mtl_material_transactions mmt

3618: mmt.organization_id,
3619: nvl(mmt.transfer_organization_id,-1),
3620: mmt.subinventory_code
3621: FROM
3622: mtl_material_transactions mmt
3623: WHERE
3624: transaction_date between l_start_date AND l_end_date
3625: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3626: AND nvl(mmt.owning_tp_type,2) = 2

Line 3660: mtl_material_transactions mmt,

3656: mmt.organization_id,
3657: nvl(mmt.transfer_organization_id,-1),
3658: mmt.subinventory_code
3659: FROM
3660: mtl_material_transactions mmt,
3661: cst_cost_group_assignments ccga
3662: WHERE
3663: transaction_date between l_start_date AND l_end_date
3664: AND transaction_action_id in (4,8,28,33,34,1,2,5,27) /* Added VMI Planning Transfer */