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 337: FROM mtl_material_transactions MMT,

333: l_stmt_num := 80;
334: /* Bug 8236035 */
335: SELECT Min(RMA.reference_line_id)
336: INTO l_so_line_id
337: FROM mtl_material_transactions MMT,
338: oe_order_lines_all RMA
339: WHERE MMT.transaction_id = i_txn_id
340: AND RMA.line_id = MMT.trx_source_line_id
341: /* Bug 8236035 */

Line 371: FROM mtl_material_transactions MMT,

367:
368: /* Added for bug 9146453*/
369: SELECT count(*)
370: INTO l_already_processed
371: FROM mtl_material_transactions MMT,
372: mtl_pac_actual_cost_details MPACD
373: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
374: AND MMT.transaction_source_type_id = 2
375: AND EXISTS (SELECT 1

Line 423: FROM mtl_material_transactions MMT,

419: i_prog_appl_id,
420: i_prog_id,
421: SYSDATE,
422: i_login_id
423: FROM mtl_material_transactions MMT,
424: mtl_pac_actual_cost_details MPACD
425: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
426: AND MMT.transaction_source_type_id = 2
427: /* Bug 8236035

Line 480: FROM mtl_material_transactions MMT,

476: i_prog_appl_id,
477: i_prog_id,
478: SYSDATE,
479: i_login_id
480: FROM mtl_material_transactions MMT,
481: mtl_cst_actual_cost_details MCACD
482: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
483: AND MMT.transaction_source_type_id = 2
484: /* Bug 8236035

Line 791: FROM mtl_material_transactions

787: INTO l_shipment_txn_id,
788: l_txn_src_type_id,
789: /*l_txn_id,*/
790: l_trp_cost -- INVCONV
791: FROM mtl_material_transactions
792: WHERE transaction_id = i_txn_id;
793:
794: IF l_debug = 'Y' THEN
795: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

Line 807: FROM mtl_material_transactions mmt,

803:
804: /* Get FOB Point */
805: SELECT nvl(mmt.fob_point,mip.fob_point)
806: INTO l_fob_point
807: FROM mtl_material_transactions mmt,
808: mtl_interorg_parameters mip
809: WHERE mmt.transaction_id = i_txn_id
810: AND mip.from_organization_id = l_from_org
811: AND mip.to_organization_id = l_to_org;

Line 880: FROM mtl_material_transactions

876:
877: /* Get transfer price from MMT */
878: SELECT transfer_price
879: INTO l_txfr_price
880: FROM mtl_material_transactions
881: WHERE transaction_id = l_shipment_txn_id;
882:
883: IF (l_txfr_price is NULL) THEN
884: fnd_file.put_line(fnd_file.log,'Transfer Price not available');

Line 1437: FROM mtl_material_transactions

1433: INTO l_txfr_percent,
1434: l_txfr_cost,
1435: l_trp_cost,
1436: l_shipment_txn_qty
1437: FROM mtl_material_transactions
1438: WHERE transaction_id = i_source_txn_id;
1439:
1440: IF l_debug = 'Y' THEN
1441: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

Line 2077: FROM mtl_material_transactions

2073: l_stmt_num := 10;
2074:
2075: SELECT primary_quantity
2076: INTO l_mta_txn_qty
2077: FROM mtl_material_transactions
2078: WHERE transaction_id = i_mta_txn_id;
2079:
2080: IF l_debug = 'Y' THEN
2081: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_mta_txn_qty = ' || l_mta_txn_qty);

Line 2259: FROM mtl_material_transactions

2255: l_stmt_num := 50;
2256:
2257: SELECT currency_conversion_type, TRUNC(transaction_date)
2258: INTO l_curr_type, l_txn_date
2259: FROM mtl_material_transactions
2260: WHERE transaction_id = i_txn_id;
2261:
2262: if (l_curr_type is NULL) then
2263: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_type);

Line 2440: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;

2436: l_parent_transaction_id NUMBER := -1;
2437: l_logical_transaction NUMBER := 3;
2438: l_parent_organization_id NUMBER := -1;
2439: l_um_rate NUMBER := 1;
2440: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2441: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2442: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2443: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2444: l_converted_txn_qty NUMBER;

Line 2441: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;

2437: l_logical_transaction NUMBER := 3;
2438: l_parent_organization_id NUMBER := -1;
2439: l_um_rate NUMBER := 1;
2440: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2441: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2442: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2443: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2444: l_converted_txn_qty NUMBER;
2445: l_stmt_num NUMBER;

Line 2468: from mtl_material_transactions

2464: transaction_action_id
2465: into l_parent_transaction_id,
2466: l_txn_src_type_id,
2467: l_txn_action_id
2468: from mtl_material_transactions
2469: where transaction_id = i_txn_id;
2470:
2471: if (l_parent_transaction_id <> -1 ) then
2472:

Line 2477: from mtl_material_transactions

2473: select organization_id,
2474: nvl(logical_transaction, 3)
2475: into l_parent_organization_id,
2476: l_logical_transaction
2477: from mtl_material_transactions
2478: where transaction_id = l_parent_transaction_id;
2479:
2480: end if;
2481:

Line 2496: UPDATE mtl_material_transactions

2492: /* Bug 6751847 fix: to prevent execution twice from both
2493: shipping and receiving cost groups,to avoid lock when run in
2494: parallel for multiple CGs */
2495:
2496: UPDATE mtl_material_transactions
2497: SET periodic_primary_quantity = (select mmt2.periodic_primary_quantity
2498: from mtl_material_transactions mmt2
2499: where mmt2.transaction_id =
2500: l_parent_transaction_id)

Line 2498: from mtl_material_transactions mmt2

2494: parallel for multiple CGs */
2495:
2496: UPDATE mtl_material_transactions
2497: SET periodic_primary_quantity = (select mmt2.periodic_primary_quantity
2498: from mtl_material_transactions mmt2
2499: where mmt2.transaction_id =
2500: l_parent_transaction_id)
2501: WHERE transaction_id = i_txn_id
2502: AND organization_id = i_txn_org_id

Line 2588: UPDATE mtl_material_transactions

2584: /* Update mmt with quantity in the master org um */
2585: /* BUG 6751847 fix: to prevent execution twice
2586: for both shipping and receiving cost group, to avoid
2587: lock when run in parallel for CGs */
2588: UPDATE mtl_material_transactions
2589: SET periodic_primary_quantity = i_txn_qty
2590: WHERE transaction_id = i_txn_id
2591: AND organization_id = i_txn_org_id
2592: AND EXISTS (SELECT 'x'

Line 2900: mtl_material_transactions mmt,

2896: nvl(mmt.transfer_organization_id,-1),
2897: mmt.subinventory_code,
2898: nvl(mmt.transfer_price,0) -- INVCONV
2899: FROM
2900: mtl_material_transactions mmt,
2901: mtl_parameters mp --INVCONV sikhanna changes
2902: WHERE
2903: transaction_date between l_start_date AND l_end_date
2904: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3272: mtl_material_transactions mmt,

3268: nvl(mmt.transfer_organization_id,-1),
3269: mmt.subinventory_code,
3270: nvl(mmt.transfer_price,0) -- INVCONV
3271: FROM
3272: mtl_material_transactions mmt,
3273: mtl_parameters mp -- INCONV sikhanna
3274: WHERE
3275: transaction_date between l_start_date AND l_end_date
3276: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3674: mtl_material_transactions mmt

3670: mmt.organization_id,
3671: nvl(mmt.transfer_organization_id,-1),
3672: mmt.subinventory_code
3673: FROM
3674: mtl_material_transactions mmt
3675: WHERE
3676: transaction_date between l_start_date AND l_end_date
3677: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3678: AND nvl(mmt.owning_tp_type,2) = 2

Line 3712: mtl_material_transactions mmt,

3708: mmt.organization_id,
3709: nvl(mmt.transfer_organization_id,-1),
3710: mmt.subinventory_code
3711: FROM
3712: mtl_material_transactions mmt,
3713: cst_cost_group_assignments ccga
3714: WHERE
3715: transaction_date between l_start_date AND l_end_date
3716: AND transaction_action_id in (4,8,28,33,34,1,2,5,27) /* Added VMI Planning Transfer */