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 1719: FROM mtl_parameters mp, mtl_material_transactions mmt

1715: IF (i_src_type_id = 8 and i_txn_act_id = 1)
1716: THEN
1717: SELECT decode(MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2), 1, 'Y', 'N')
1718: INTO l_pd_xfer_ind
1719: FROM mtl_parameters mp, mtl_material_transactions mmt
1720: WHERE mmt.transaction_id = i_txn_id
1721: AND (mp.organization_id = mmt.organization_id
1722: OR mp.organization_id = mmt.transfer_organization_id);
1723: END IF;

Line 1830: from rcv_transactions rt, mtl_material_transactions mmt

1826:
1827: l_stmt_num := 35;
1828: select rt.dropship_type_code
1829: into l_drop_ship_type_code
1830: from rcv_transactions rt, mtl_material_transactions mmt
1831: where rt.transaction_id = mmt.rcv_transaction_id
1832: and mmt.transaction_id = i_txn_id;
1833:
1834: if (l_drop_ship_type_code = 1 OR l_drop_ship_type_code = 2) then

Line 1995: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1991: INTO l_txfr_org_id,
1992: l_txfr_txn_id,
1993: l_transfer_price,
1994: l_pd_xfer_ind
1995: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1996: MTL_PARAMETERS mp, MTL_PARAMETERS mpx
1997: WHERE mmt.transaction_id = i_txn_id
1998: AND mp.organization_id = mmt.organization_id
1999: AND mpx.organization_id = mmt.transfer_organization_id;

Line 2020: FROM MTL_MATERIAL_TRANSACTIONS

2016:
2017: ELSE
2018: SELECT DISTRIBUTION_ACCOUNT_ID
2019: INTO l_acct
2020: FROM MTL_MATERIAL_TRANSACTIONS
2021: WHERE transaction_id = l_txfr_txn_id;
2022:
2023: l_acct_line_type := 2;
2024: END IF;

Line 2649: from mtl_interorg_parameters MIP, mtl_material_transactions MMT

2645: l_io_rec_acct,
2646: l_io_pay_acct,
2647: l_io_ppv_acct,
2648: l_io_profit_acct -- OPM INVCONV umoogala
2649: from mtl_interorg_parameters MIP, mtl_material_transactions MMT
2650: where MIP.from_organization_id = l_from_org
2651: and MIP.to_organization_id = l_to_org
2652: and MMT.transaction_id = i_txn_id;
2653:

Line 3606: update mtl_material_transactions

3602:
3603:
3604: -- Changes for PJM for Standard Costing
3605: l_stmt_num := 95;
3606: update mtl_material_transactions
3607: set variance_amount = l_ppv * abs(l_rcv_qty)
3608: where transaction_id = i_txn_id
3609: and organization_id = l_std_org;
3610:

Line 3875: update mtl_material_transactions

3871:
3872:
3873: /* Changes for PJM for Standard Costing */
3874: l_stmt_num := 95;
3875: update mtl_material_transactions
3876: set variance_amount = l_ppv * abs(l_rcv_qty)
3877: where transaction_id = i_txn_id
3878: and organization_id = l_std_org;
3879:

Line 5068: from mtl_material_transactions

5064: -- used in the distributions since primary quantity and transaction
5065: -- quantity are 0.
5066: select quantity_adjusted, transaction_cost
5067: into l_qty_adj, l_txn_cost
5068: from mtl_material_transactions
5069: where transaction_id = i_txn_id;
5070:
5071: l_stmt_num := 30;
5072: -- The supplier accrual account is stored in MMT.dist_acct_id

Line 5547: from mtl_material_transactions mmt

5543: -- borrow payback
5544: l_stmt_num := 35;
5545: select mmt.transaction_type_id, mmt.transaction_action_id
5546: into l_txn_type, l_txn_action_id
5547: from mtl_material_transactions mmt
5548: where mmt.transaction_id = i_txn_id;
5549: -- borrow payback end
5550:
5551:

Line 6604: FROM mtl_material_transactions

6600: l_stmt_num := 2;
6601: IF(l_enc_rev = 1) THEN
6602: SELECT transaction_type_id
6603: INTO l_txn_type
6604: FROM mtl_material_transactions
6605: WHERE transaction_id = i_txn_id;
6606:
6607: IF( (l_txn_type = 18) OR (l_txn_type = 36) OR (l_txn_type = 71) ) THEN
6608:

Line 6613: FROM mtl_material_transactions mmt,

6609: IF(i_acct_line_type = 1 AND i_cost_element_id = 1) THEN
6610: l_stmt_num := 3;
6611: SELECT rsl.ussgl_transaction_code
6612: INTO l_ussgl_tc
6613: FROM mtl_material_transactions mmt,
6614: rcv_transactions rt,
6615: rcv_shipment_lines rsl
6616: WHERE mmt.transaction_id = i_txn_id
6617: AND mmt.rcv_transaction_id = rt.transaction_id

Line 6625: FROM mtl_material_transactions mmt,

6621:
6622: l_stmt_num := 4;
6623: SELECT POD.ussgl_transaction_code
6624: INTO l_ussgl_tc
6625: FROM mtl_material_transactions mmt,
6626: rcv_transactions rt,
6627: po_distributions_all pod
6628: WHERE mmt.transaction_id = i_txn_id
6629: AND mmt.rcv_transaction_id = rt.transaction_id

Line 7150: from mtl_material_transactions

7146: conv_rate, conv_type,
7147: enc_acct, enc_amt,
7148: var_amt, mv_idmvi,
7149: txn_type_id, interorg_xfr_price
7150: from mtl_material_transactions
7151: where transaction_id = trans_id;
7152:
7153:
7154: -- code to stop profile is at the end of this procedure.

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

7571: io_pay_acct,
7572: io_ppv_acct,
7573: acv_acct, /* overwrite sending acv_acct */
7574: interorg_profit_acct
7575: FROM mtl_interorg_parameters mip, mtl_parameters mp, mtl_material_transactions mmt
7576: WHERE mip.from_organization_id = from_org
7577: AND mip.to_organization_id = to_org
7578: AND mp.organization_id = org_id
7579: AND mmt.transaction_id = trans_id;

Line 8330: UPDATE mtl_material_transactions

8326:
8327: /* Changes for PJM Standard Costing - Update MMT with PPV amount*/
8328:
8329:
8330: UPDATE mtl_material_transactions
8331: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8332: FROM mtl_transaction_accounts mta
8333: WHERE mta.transaction_id = trans_id
8334: AND mta.organization_id = org_id

Line 8612: UPDATE mtl_material_transactions

8608:
8609: IF (txn_act_id <> 17) -- Bug 5349860
8610: THEN
8611:
8612: UPDATE mtl_material_transactions
8613: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8614: FROM mtl_transaction_accounts mta
8615: WHERE mta.transaction_id = trans_id
8616: AND mta.organization_id = org_id

Line 9158: UPDATE mtl_material_transactions

9154: | Dr PPV with above amount
9155: +----------------------------------------------------------------------*/
9156: -- ppv_amt := (item_cost * p_qty) - ((interorg_xfr_price * p_qty) + trp_cost);
9157:
9158: UPDATE mtl_material_transactions
9159: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
9160: FROM mtl_transaction_accounts mta
9161: WHERE mta.transaction_id = trans_id
9162: AND mta.organization_id = org_id

Line 9365: UPDATE mtl_material_transactions

9361: -- }
9362: end if;
9363:
9364: l_stmt_num := 954;
9365: UPDATE mtl_material_transactions
9366: SET transaction_cost = (((txf_price*abs(p_qty))+nvl(trp_cost,0))/abs(p_qty))
9367: WHERE transaction_id = trans_id;
9368:
9369: l_stmt_num := 957;

Line 9370: UPDATE mtl_material_transactions

9366: SET transaction_cost = (((txf_price*abs(p_qty))+nvl(trp_cost,0))/abs(p_qty))
9367: WHERE transaction_id = trans_id;
9368:
9369: l_stmt_num := 957;
9370: UPDATE mtl_material_transactions
9371: SET costed_flag = NULL,
9372: transaction_group_id = NULL,
9373: request_id = req_id,
9374: program_application_id = prg_appid,

Line 9454: UPDATE mtl_material_transactions

9450: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||
9451: substr(O_Error_Message, 1, 180);
9452:
9453:
9454: UPDATE mtl_material_transactions
9455: SET costed_flag = 'E',
9456: error_code = substrb(O_Error_Code,1,240),
9457: error_explanation = substrb(O_Error_Message,1,240),
9458: request_id = req_id,

Line 9470: UPDATE mtl_material_transactions

9466:
9467: WHEN FND_API.g_exc_unexpected_error THEN
9468: rollback;
9469:
9470: UPDATE mtl_material_transactions
9471: SET costed_flag = 'E',
9472: error_code = substrb(O_Error_Code,1,240),
9473: error_explanation = substrb(O_Error_Message,1,240),
9474: request_id = req_id,

Line 9490: UPDATE mtl_material_transactions

9486: O_error_num := SQLCODE;
9487: O_error_code := SQLCODE;
9488: O_error_message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || to_char(l_stmt_num) || '): '|| substr(SQLERRM,1,180);
9489:
9490: UPDATE mtl_material_transactions
9491: SET costed_flag = 'E',
9492: error_code = substrb(O_Error_Code,1,240),
9493: error_explanation = substrb(O_Error_Message,1,240),
9494: request_id = req_id,