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.CSTPSMUT dependencies on MTL_TRANSACTION_ACCOUNTS

Line 836: x_err_code := 'Error inserting into MTL Transaction Accounts';

832: x_err_code := 'Error inserting into Wip Transaction Accounts';
833: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
834: WHEN FAILED_INSERTING_MTA THEN
835: x_err_num := -1;
836: x_err_code := 'Error inserting into MTL Transaction Accounts';
837: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
838: WHEN FAILED_INSERTING_RESULT_LOT THEN
839: x_err_num := -1;
840: x_err_code := 'Error inserting into WPB for Resulting Lot';

Line 837: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

833: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
834: WHEN FAILED_INSERTING_MTA THEN
835: x_err_num := -1;
836: x_err_code := 'Error inserting into MTL Transaction Accounts';
837: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
838: WHEN FAILED_INSERTING_RESULT_LOT THEN
839: x_err_num := -1;
840: x_err_code := 'Error inserting into WPB for Resulting Lot';
841: x_err_msg := 'Error inserting into WPB for Resulting Lot: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 1694: x_err_code := 'Error inserting into MTL Transaction Accounts';

1690: x_err_code := 'Error inserting into Wip Transaction Accounts';
1691: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1692: WHEN FAILED_INSERTING_MTA THEN
1693: x_err_num := -1;
1694: x_err_code := 'Error inserting into MTL Transaction Accounts';
1695: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1696: WHEN FAILED_INSERTING_RESULT_LOT THEN
1697: x_err_num := -1;
1698: x_err_code := 'Error inserting into WPB for Resulting Lot';

Line 1695: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

1691: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1692: WHEN FAILED_INSERTING_MTA THEN
1693: x_err_num := -1;
1694: x_err_code := 'Error inserting into MTL Transaction Accounts';
1695: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1696: WHEN FAILED_INSERTING_RESULT_LOT THEN
1697: x_err_num := -1;
1698: x_err_code := 'Error inserting into WPB for Resulting Lot';
1699: x_err_msg := 'Error inserting into WPB for Resulting Lot: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2254: x_err_code := 'Error inserting into MTL Transaction Accounts';

2250: x_err_code := 'Error inserting into Wip Transaction Accounts';
2251: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2252: WHEN FAILED_INSERTING_MTA THEN
2253: x_err_num := -1;
2254: x_err_code := 'Error inserting into MTL Transaction Accounts';
2255: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2256: WHEN FAILED_INSERTING_BONUS_MTA THEN
2257: x_err_num := -1;
2258: x_err_code := 'Error inserting into MTL Bonus Accounts';

Line 2255: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

2251: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2252: WHEN FAILED_INSERTING_MTA THEN
2253: x_err_num := -1;
2254: x_err_code := 'Error inserting into MTL Transaction Accounts';
2255: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2256: WHEN FAILED_INSERTING_BONUS_MTA THEN
2257: x_err_num := -1;
2258: x_err_code := 'Error inserting into MTL Bonus Accounts';
2259: x_err_msg := 'Error inserting into MTL Bonus Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2820: x_err_code := 'Error inserting into MTL Transaction Accounts';

2816: x_err_code := 'Error inserting into Wip Transaction Accounts';
2817: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2818: WHEN FAILED_INSERTING_MTA THEN
2819: x_err_num := -1;
2820: x_err_code := 'Error inserting into MTL Transaction Accounts';
2821: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2822: WHEN FAILED_INSERTING_BONUS_MTA THEN
2823: x_err_num := -1;
2824: x_err_code := 'Error inserting into MTL Bonus Accounts';

Line 2821: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

2817: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2818: WHEN FAILED_INSERTING_MTA THEN
2819: x_err_num := -1;
2820: x_err_code := 'Error inserting into MTL Transaction Accounts';
2821: x_err_msg := 'Error inserting into MTL Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2822: WHEN FAILED_INSERTING_BONUS_MTA THEN
2823: x_err_num := -1;
2824: x_err_code := 'Error inserting into MTL Bonus Accounts';
2825: x_err_msg := 'Error inserting into MTL Bonus Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 4036: FROM mtl_transaction_accounts

4032:
4033: -- find out if the credit and debit are balanced in MTA
4034: SELECT sum(base_transaction_value)
4035: INTO l_mta_total_sum
4036: FROM mtl_transaction_accounts
4037: WHERE transaction_id in (p_mtl_txn_id);
4038:
4039: l_stmt_num := 20;
4040: IF l_mta_total_sum <> 0 THEN

Line 4050: -- FROM mtl_transaction_accounts

4046: -- Get the sum of all child lots
4047:
4048: -- SELECT sum(base_transaction_value)
4049: -- INTO temp_value
4050: -- FROM mtl_transaction_accounts
4051: -- WHERE transaction_id in (p_mtl_txn_id)
4052: -- AND base_transaction_value > 0;
4053:
4054: -- get the sum of debit/credit except the rep. lot highest cost element.

Line 4059: FROM mtl_transaction_accounts

4055:
4056: l_stmt_num := 30;
4057: SELECT sum(base_transaction_value)
4058: INTO l_mta_temp_value
4059: FROM mtl_transaction_accounts
4060: WHERE transaction_id in (p_mtl_txn_id)
4061: AND NOT (cost_element_id = (SELECT MAX(mta1.cost_element_id)
4062: FROM mtl_transaction_accounts mta1
4063: WHERE mta1.transaction_id = p_mtl_txn_id

Line 4062: FROM mtl_transaction_accounts mta1

4058: INTO l_mta_temp_value
4059: FROM mtl_transaction_accounts
4060: WHERE transaction_id in (p_mtl_txn_id)
4061: AND NOT (cost_element_id = (SELECT MAX(mta1.cost_element_id)
4062: FROM mtl_transaction_accounts mta1
4063: WHERE mta1.transaction_id = p_mtl_txn_id
4064: AND mta1.base_transaction_value < 0 )
4065: AND base_transaction_value < 0);
4066:

Line 4069: UPDATE mtl_transaction_accounts mta

4065: AND base_transaction_value < 0);
4066:
4067: -- update the base txn value for the variance
4068: l_stmt_num := 40;
4069: UPDATE mtl_transaction_accounts mta
4070: SET base_transaction_value = -1 * (l_mta_temp_value)
4071: WHERE mta.transaction_id = p_mtl_txn_id
4072: AND mta.cost_element_id = (SELECT MAX(mta1.cost_element_id)
4073: FROM mtl_transaction_accounts mta1

Line 4073: FROM mtl_transaction_accounts mta1

4069: UPDATE mtl_transaction_accounts mta
4070: SET base_transaction_value = -1 * (l_mta_temp_value)
4071: WHERE mta.transaction_id = p_mtl_txn_id
4072: AND mta.cost_element_id = (SELECT MAX(mta1.cost_element_id)
4073: FROM mtl_transaction_accounts mta1
4074: WHERE mta1.transaction_id = p_mtl_txn_id
4075: AND mta.base_transaction_value < 0)
4076: AND mta.base_transaction_value < 0;
4077:

Line 4087: FROM mtl_transaction_accounts

4083:
4084: l_stmt_num := 60;
4085: SELECT sum(base_transaction_value)
4086: INTO l_mta_temp_value
4087: FROM mtl_transaction_accounts
4088: WHERE transaction_id in (p_mtl_txn_id)
4089: AND NOT (cost_element_id = (SELECT MAX(mta1.cost_element_id)
4090: FROM mtl_transaction_accounts mta1
4091: WHERE mta1.transaction_id = p_mtl_txn_id

Line 4090: FROM mtl_transaction_accounts mta1

4086: INTO l_mta_temp_value
4087: FROM mtl_transaction_accounts
4088: WHERE transaction_id in (p_mtl_txn_id)
4089: AND NOT (cost_element_id = (SELECT MAX(mta1.cost_element_id)
4090: FROM mtl_transaction_accounts mta1
4091: WHERE mta1.transaction_id = p_mtl_txn_id
4092: AND mta1.base_transaction_value > 0 )
4093: AND base_transaction_value > 0);
4094:

Line 4097: UPDATE mtl_transaction_accounts mta

4093: AND base_transaction_value > 0);
4094:
4095: l_stmt_num := 70;
4096: -- update the base txn value for the variance
4097: UPDATE mtl_transaction_accounts mta
4098: SET base_transaction_value = -1 * (l_mta_temp_value)
4099: WHERE mta.transaction_id = p_mtl_txn_id
4100: AND mta.cost_element_id = (SELECT MAX(mta1.cost_element_id)
4101: FROM mtl_transaction_accounts mta1

Line 4101: FROM mtl_transaction_accounts mta1

4097: UPDATE mtl_transaction_accounts mta
4098: SET base_transaction_value = -1 * (l_mta_temp_value)
4099: WHERE mta.transaction_id = p_mtl_txn_id
4100: AND mta.cost_element_id = (SELECT MAX(mta1.cost_element_id)
4101: FROM mtl_transaction_accounts mta1
4102: WHERE mta1.transaction_id = p_mtl_txn_id
4103: AND mta1.base_transaction_value > 0)
4104: AND mta.base_transaction_value > 0;
4105:

Line 4112: FROM mtl_transaction_accounts

4108:
4109: l_stmt_num := 80;
4110: SELECT sum(base_transaction_value)
4111: INTO l_mta_temp_value
4112: FROM mtl_transaction_accounts
4113: WHERE transaction_id in (p_mtl_txn_id)
4114: AND base_transaction_value > 0;
4115:
4116: l_stmt_num := 90;

Line 4117: UPDATE mtl_transaction_accounts mta

4113: WHERE transaction_id in (p_mtl_txn_id)
4114: AND base_transaction_value > 0;
4115:
4116: l_stmt_num := 90;
4117: UPDATE mtl_transaction_accounts mta
4118: SET base_transaction_value = -1 * (l_mta_temp_value)
4119: WHERE mta.transaction_id = p_mtl_txn_id
4120: AND mta.cost_element_id is null;
4121:

Line 4271: FROM mtl_transaction_accounts

4267: AND mtt.transaction_action_id = p_action_id
4268: AND mtt.transaction_source_type_id = p_source_type_id
4269: AND exists
4270: ( SELECT null
4271: FROM mtl_transaction_accounts
4272: WHERE transaction_id = p_mtl_txn_id);
4273:
4274: l_rows_inserted := SQL%ROWCOUNT;
4275:

Line 4414: INSERT into mtl_transaction_accounts (

4410:
4411: l_stmt_num := 10;
4412:
4413:
4414: INSERT into mtl_transaction_accounts (
4415: TRANSACTION_ID,
4416: REFERENCE_ACCOUNT,
4417: LAST_UPDATE_DATE,
4418: LAST_UPDATED_BY,

Line 4471: UPDATE MTL_TRANSACTION_ACCOUNTS

4467:
4468: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
4469:
4470: /* R12 - Sub Ledger Unique Identifier */
4471: UPDATE MTL_TRANSACTION_ACCOUNTS
4472: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4473: WHERE TRANSACTION_ID = p_mtl_txn_id;
4474:
4475: IF (l_rows_inserted > 0) and (p_debug = 'Y')THEN

Line 4478: || 'into mtl_transaction_accounts.'

4474:
4475: IF (l_rows_inserted > 0) and (p_debug = 'Y')THEN
4476: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(l_rows_inserted)
4477: || ' row(s) inserted '
4478: || 'into mtl_transaction_accounts.'
4479: || ',mtl_txn_id: '
4480: || p_mtl_txn_id
4481: || ', cost element id: '
4482: || p_cost_element_id

Line 4705: INSERT into mtl_transaction_accounts

4701: l_stmt_num := 10;
4702: p_err_num := 0;
4703:
4704:
4705: INSERT into mtl_transaction_accounts
4706: (
4707: TRANSACTION_ID, REFERENCE_ACCOUNT, LAST_UPDATE_DATE,
4708: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
4709: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 4729: UPDATE MTL_TRANSACTION_ACCOUNTS

4725: WHERE transaction_id = p_sm_txn_id
4726: HAVING ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit <> 0;
4727: l_rows_inserted := SQL%ROWCOUNT;
4728:
4729: UPDATE MTL_TRANSACTION_ACCOUNTS
4730: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4731: WHERE TRANSACTION_ID = p_mtl_txn_id;
4732:
4733: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN

Line 4736: || 'into mtl_transaction_accounts '

4732:
4733: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4734: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4735: || ' row(s) inserted '
4736: || 'into mtl_transaction_accounts '
4737: || ', mtl_txn_id: '
4738: || p_mtl_txn_id);
4739: END IF;
4740:

Line 4851: FROM mtl_transaction_accounts mta

4847: -mta.base_transaction_value, 0)), 0),
4848: nvl(wpb.pl_overhead_out, 0) +
4849: nvl(SUM(DECODE(mta.cost_element_id,5,
4850: -mta.base_transaction_value, 0)), 0)
4851: FROM mtl_transaction_accounts mta
4852: WHERE mta.transaction_id = p_sl_mtl_txn_id
4853: AND mta.transaction_source_id = p_sl_wip_id)
4854: -- AND mta.accounting_line_type <> 31)
4855: WHERE wpb.wip_entity_id = p_sl_wip_id

Line 4859: FROM mtl_transaction_accounts

4855: WHERE wpb.wip_entity_id = p_sl_wip_id
4856: AND wpb.acct_period_id = p_acct_period_id
4857: AND exists
4858: ( SELECT null
4859: FROM mtl_transaction_accounts
4860: WHERE transaction_id = p_sl_mtl_txn_id);
4861:
4862: l_rows_inserted := SQL%ROWCOUNT;
4863: -- dbms_output.put_line(to_char(l_rows_inserted) || 'row(s) updated ' ||

Line 4976: FROM mtl_transaction_accounts mta

4972: mta.base_transaction_value, 0)), 0),
4973: nvl(wpb.pl_overhead_in, 0) +
4974: nvl(SUM(DECODE(mta.cost_element_id,5,
4975: mta.base_transaction_value, 0)), 0)
4976: FROM mtl_transaction_accounts mta
4977: WHERE mta.transaction_id = p_rl_mtl_txn_id
4978: AND mta.transaction_source_id = p_rl_wip_id)
4979: WHERE wpb.wip_entity_id = p_rl_wip_id
4980: AND wpb.acct_period_id = p_acct_period_id

Line 4983: FROM mtl_transaction_accounts

4979: WHERE wpb.wip_entity_id = p_rl_wip_id
4980: AND wpb.acct_period_id = p_acct_period_id
4981: AND exists
4982: ( SELECT null
4983: FROM mtl_transaction_accounts
4984: WHERE transaction_id = p_rl_mtl_txn_id);
4985:
4986: l_rows_inserted := SQL%ROWCOUNT;
4987: IF (p_debug = 'Y') and (l_rows_inserted > 0) THEN