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.CSTPACDP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 221: from mtl_material_transactions

217: l_so_issue_accounting,
218: l_cogs_percentage,
219: l_rcv_transaction_id,
220: l_onhand_var_acct
221: from mtl_material_transactions
222: where transaction_id = i_txn_id;
223:
224: /* NL Changes */
225: l_stmt_num := 12;

Line 1810: FROM mtl_parameters mp, mtl_material_transactions mmt

1806: IF (i_src_type_id = 8 and i_txn_act_id = 1)
1807: THEN
1808: SELECT decode(MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2), 1, 'Y', 'N')
1809: INTO l_pd_xfer_ind
1810: FROM mtl_parameters mp, mtl_material_transactions mmt
1811: WHERE mmt.transaction_id = i_txn_id
1812: AND (mp.organization_id = mmt.organization_id
1813: OR mp.organization_id = mmt.transfer_organization_id);
1814: END IF;

Line 1921: from rcv_transactions rt, mtl_material_transactions mmt

1917:
1918: l_stmt_num := 35;
1919: select rt.dropship_type_code
1920: into l_drop_ship_type_code
1921: from rcv_transactions rt, mtl_material_transactions mmt
1922: where rt.transaction_id = mmt.rcv_transaction_id
1923: and mmt.transaction_id = i_txn_id;
1924:
1925: if (l_drop_ship_type_code = 1 OR l_drop_ship_type_code = 2) then

Line 2086: FROM MTL_MATERIAL_TRANSACTIONS mmt,

2082: INTO l_txfr_org_id,
2083: l_txfr_txn_id,
2084: l_transfer_price,
2085: l_pd_xfer_ind
2086: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2087: MTL_PARAMETERS mp, MTL_PARAMETERS mpx
2088: WHERE mmt.transaction_id = i_txn_id
2089: AND mp.organization_id = mmt.organization_id
2090: AND mpx.organization_id = mmt.transfer_organization_id;

Line 2111: FROM MTL_MATERIAL_TRANSACTIONS

2107:
2108: ELSE
2109: SELECT DISTRIBUTION_ACCOUNT_ID
2110: INTO l_acct
2111: FROM MTL_MATERIAL_TRANSACTIONS
2112: WHERE transaction_id = l_txfr_txn_id;
2113:
2114: l_acct_line_type := 2;
2115: END IF;

Line 2740: from mtl_interorg_parameters MIP, mtl_material_transactions MMT

2736: l_io_rec_acct,
2737: l_io_pay_acct,
2738: l_io_ppv_acct,
2739: l_io_profit_acct -- OPM INVCONV umoogala
2740: from mtl_interorg_parameters MIP, mtl_material_transactions MMT
2741: where MIP.from_organization_id = l_from_org
2742: and MIP.to_organization_id = l_to_org
2743: and MMT.transaction_id = i_txn_id;
2744:

Line 3697: update mtl_material_transactions

3693:
3694:
3695: -- Changes for PJM for Standard Costing
3696: l_stmt_num := 95;
3697: update mtl_material_transactions
3698: set variance_amount = l_ppv * abs(l_rcv_qty)
3699: where transaction_id = i_txn_id
3700: and organization_id = l_std_org;
3701:

Line 3966: update mtl_material_transactions

3962:
3963:
3964: /* Changes for PJM for Standard Costing */
3965: l_stmt_num := 95;
3966: update mtl_material_transactions
3967: set variance_amount = l_ppv * abs(l_rcv_qty)
3968: where transaction_id = i_txn_id
3969: and organization_id = l_std_org;
3970:

Line 5160: from mtl_material_transactions

5156: -- used in the distributions since primary quantity and transaction
5157: -- quantity are 0.
5158: select quantity_adjusted, transaction_cost
5159: into l_qty_adj, l_txn_cost
5160: from mtl_material_transactions
5161: where transaction_id = i_txn_id;
5162:
5163: l_stmt_num := 30;
5164: -- The supplier accrual account is stored in MMT.dist_acct_id

Line 5639: from mtl_material_transactions mmt

5635: -- borrow payback
5636: l_stmt_num := 35;
5637: select mmt.transaction_type_id, mmt.transaction_action_id
5638: into l_txn_type, l_txn_action_id
5639: from mtl_material_transactions mmt
5640: where mmt.transaction_id = i_txn_id;
5641: -- borrow payback end
5642:
5643:

Line 6725: FROM mtl_material_transactions

6721: l_stmt_num := 2;
6722: IF(l_enc_rev = 1) THEN
6723: SELECT transaction_type_id
6724: INTO l_txn_type
6725: FROM mtl_material_transactions
6726: WHERE transaction_id = i_txn_id;
6727:
6728: IF( (l_txn_type = 18) OR (l_txn_type = 36) OR (l_txn_type = 71) ) THEN
6729:

Line 6734: FROM mtl_material_transactions mmt,

6730: IF(i_acct_line_type = 1 AND i_cost_element_id = 1) THEN
6731: l_stmt_num := 3;
6732: SELECT rsl.ussgl_transaction_code
6733: INTO l_ussgl_tc
6734: FROM mtl_material_transactions mmt,
6735: rcv_transactions rt,
6736: rcv_shipment_lines rsl
6737: WHERE mmt.transaction_id = i_txn_id
6738: AND mmt.rcv_transaction_id = rt.transaction_id

Line 6746: FROM mtl_material_transactions mmt,

6742:
6743: l_stmt_num := 4;
6744: SELECT POD.ussgl_transaction_code, nvl(pod.rate,1), pod.rate_date, poh.rate_type
6745: INTO l_ussgl_tc, l_conv_rate, l_conv_date, l_conv_type
6746: FROM mtl_material_transactions mmt,
6747: rcv_transactions rt,
6748: po_distributions_all pod,
6749: po_headers_all poh
6750: WHERE mmt.transaction_id = i_txn_id

Line 7349: from mtl_material_transactions

7345: conv_rate, conv_type,
7346: enc_acct, enc_amt,
7347: var_amt, mv_idmvi,
7348: txn_type_id, interorg_xfr_price
7349: from mtl_material_transactions
7350: where transaction_id = trans_id;
7351:
7352:
7353: -- code to stop profile is at the end of this procedure.

Line 7774: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt

7770: io_pay_acct,
7771: io_ppv_acct,
7772: acv_acct, /* overwrite sending acv_acct */
7773: interorg_profit_acct
7774: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt
7775: WHERE mip.from_organization_id = from_org
7776: AND mip.to_organization_id = to_org
7777: AND mp.organization_id = org_id
7778: AND mmt.transaction_id = trans_id;

Line 8529: UPDATE mtl_material_transactions

8525:
8526: /* Changes for PJM Standard Costing - Update MMT with PPV amount*/
8527:
8528:
8529: UPDATE mtl_material_transactions
8530: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8531: FROM mtl_transaction_accounts mta
8532: WHERE mta.transaction_id = trans_id
8533: AND mta.organization_id = org_id

Line 8811: UPDATE mtl_material_transactions

8807:
8808: IF (txn_act_id <> 17) -- Bug 5349860
8809: THEN
8810:
8811: UPDATE mtl_material_transactions
8812: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8813: FROM mtl_transaction_accounts mta
8814: WHERE mta.transaction_id = trans_id
8815: AND mta.organization_id = org_id

Line 9357: UPDATE mtl_material_transactions

9353: | Dr PPV with above amount
9354: +----------------------------------------------------------------------*/
9355: -- ppv_amt := (item_cost * p_qty) - ((interorg_xfr_price * p_qty) + trp_cost);
9356:
9357: UPDATE mtl_material_transactions
9358: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
9359: FROM mtl_transaction_accounts mta
9360: WHERE mta.transaction_id = trans_id
9361: AND mta.organization_id = org_id

Line 9564: UPDATE mtl_material_transactions

9560: -- }
9561: end if;
9562:
9563: l_stmt_num := 954;
9564: UPDATE mtl_material_transactions
9565: SET transaction_cost = (((txf_price*abs(p_qty))+nvl(trp_cost,0))/abs(p_qty))
9566: WHERE transaction_id = trans_id;
9567:
9568: l_stmt_num := 957;

Line 9569: UPDATE mtl_material_transactions

9565: SET transaction_cost = (((txf_price*abs(p_qty))+nvl(trp_cost,0))/abs(p_qty))
9566: WHERE transaction_id = trans_id;
9567:
9568: l_stmt_num := 957;
9569: UPDATE mtl_material_transactions
9570: SET costed_flag = NULL,
9571: transaction_group_id = NULL,
9572: request_id = req_id,
9573: program_application_id = prg_appid,

Line 9653: UPDATE mtl_material_transactions

9649: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||
9650: substr(O_Error_Message, 1, 180);
9651:
9652:
9653: UPDATE mtl_material_transactions
9654: SET costed_flag = 'E',
9655: error_code = substrb(O_Error_Code,1,240),
9656: error_explanation = substrb(O_Error_Message,1,240),
9657: request_id = req_id,

Line 9669: UPDATE mtl_material_transactions

9665:
9666: WHEN FND_API.g_exc_unexpected_error THEN
9667: rollback;
9668:
9669: UPDATE mtl_material_transactions
9670: SET costed_flag = 'E',
9671: error_code = substrb(O_Error_Code,1,240),
9672: error_explanation = substrb(O_Error_Message,1,240),
9673: request_id = req_id,

Line 9689: UPDATE mtl_material_transactions

9685: O_error_num := SQLCODE;
9686: O_error_code := SQLCODE;
9687: O_error_message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || to_char(l_stmt_num) || '): '|| substr(SQLERRM,1,180);
9688:
9689: UPDATE mtl_material_transactions
9690: SET costed_flag = 'E',
9691: error_code = substrb(O_Error_Code,1,240),
9692: error_explanation = substrb(O_Error_Message,1,240),
9693: request_id = req_id,