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 WIP_TRANSACTION_ACCOUNTS

Line 771: FROM WIP_TRANSACTION_ACCOUNTS

767: l_stmt_num := 200;
768:
769: SELECT count(*)
770: INTO l_wta_exists
771: FROM WIP_TRANSACTION_ACCOUNTS
772: WHERE transaction_id = l_wip_transaction_id
773: and rownum=1;
774:
775: IF l_wta_exists > 0 THEN

Line 832: x_err_code := 'Error inserting into Wip Transaction Accounts';

828: x_err_code := 9999;
829: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
830: WHEN FAILED_INSERTING_WTA THEN
831: x_err_num := -1;
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';

Line 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);

829: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
830: WHEN FAILED_INSERTING_WTA THEN
831: x_err_num := -1;
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);

Line 1628: FROM WIP_TRANSACTION_ACCOUNTS

1624: l_stmt_num := 200;
1625:
1626: SELECT count(*)
1627: INTO l_wta_exists
1628: FROM WIP_TRANSACTION_ACCOUNTS
1629: WHERE transaction_id = l_wip_transaction_id
1630: and rownum=1;
1631:
1632: IF l_wta_exists > 0 THEN

Line 1690: x_err_code := 'Error inserting into Wip Transaction Accounts';

1686: x_err_code := 'Error inserting into Wip Transactions';
1687: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1688: WHEN FAILED_INSERTING_WTA THEN
1689: x_err_num := -1;
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';

Line 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);

1687: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1688: WHEN FAILED_INSERTING_WTA THEN
1689: x_err_num := -1;
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);

Line 2192: FROM WIP_TRANSACTION_ACCOUNTS

2188: l_stmt_num := 155;
2189:
2190: SELECT count(*)
2191: INTO l_wta_exists
2192: FROM WIP_TRANSACTION_ACCOUNTS
2193: WHERE transaction_id = l_wip_transaction_id
2194: and rownum=1;
2195:
2196:

Line 2250: x_err_code := 'Error inserting into Wip Transaction Accounts';

2246: x_err_code := 'Error inserting into Wip Transactions';
2247: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2248: WHEN FAILED_INSERTING_WTA THEN
2249: x_err_num := -1;
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';

Line 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);

2247: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2248: WHEN FAILED_INSERTING_WTA THEN
2249: x_err_num := -1;
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);

Line 2755: FROM WIP_TRANSACTION_ACCOUNTS

2751: l_stmt_num := 155;
2752:
2753: SELECT count(*)
2754: INTO l_wta_exists
2755: FROM WIP_TRANSACTION_ACCOUNTS
2756: WHERE transaction_id = l_wip_transaction_id
2757: and rownum=1;
2758:
2759: IF l_wta_exists > 0 THEN

Line 2816: x_err_code := 'Error inserting into Wip Transaction Accounts';

2812: x_err_code := 'Error inserting into Wip Transactions';
2813: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2814: WHEN FAILED_INSERTING_WTA THEN
2815: x_err_num := -1;
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';

Line 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);

2813: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2814: WHEN FAILED_INSERTING_WTA THEN
2815: x_err_num := -1;
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);

Line 4129: FROM wip_transaction_accounts wta

4125: l_stmt_num := 100;
4126: -- balance credit / debit in wta
4127: SELECT sum(base_transaction_value)
4128: INTO l_wta_total_sum
4129: FROM wip_transaction_accounts wta
4130: WHERE transaction_id in (p_wip_txn_id);
4131:
4132:
4133: l_stmt_num := 110;

Line 4140: -- FROM wip_transaction_accounts

4136:
4137: l_stmt_num := 120;
4138: -- SELECT sum(base_transaction_value)
4139: -- INTO temp_value
4140: -- FROM wip_transaction_accounts
4141: -- WHERE transaction_id in (p_wip_txn_id)
4142: -- AND base_transaction_value > 0;
4143:
4144: l_stmt_num := 130;

Line 4147: FROM wip_transaction_accounts wta

4143:
4144: l_stmt_num := 130;
4145: SELECT sum(base_transaction_value)
4146: INTO l_wta_temp_value
4147: FROM wip_transaction_accounts wta
4148: WHERE transaction_id in (p_wip_txn_id)
4149: AND NOT ( cost_element_id = (SELECT MAX(cost_element_id)
4150: FROM wip_transaction_accounts wta1
4151: WHERE wta1.transaction_id = p_wip_txn_id

Line 4150: FROM wip_transaction_accounts wta1

4146: INTO l_wta_temp_value
4147: FROM wip_transaction_accounts wta
4148: WHERE transaction_id in (p_wip_txn_id)
4149: AND NOT ( cost_element_id = (SELECT MAX(cost_element_id)
4150: FROM wip_transaction_accounts wta1
4151: WHERE wta1.transaction_id = p_wip_txn_id
4152: AND wta1.base_transaction_value < 0 )
4153: AND wta.base_transaction_value < 0);
4154:

Line 4156: UPDATE wip_transaction_accounts wta

4152: AND wta1.base_transaction_value < 0 )
4153: AND wta.base_transaction_value < 0);
4154:
4155: l_stmt_num := 140;
4156: UPDATE wip_transaction_accounts wta
4157: SET wta.base_transaction_value = -1*(l_wta_temp_value)
4158: WHERE transaction_id in (p_wip_txn_id)
4159: AND (base_transaction_value < 0
4160: and cost_element_id=(SELECT MAX(cost_element_id)

Line 4161: FROM wip_transaction_accounts wta1

4157: SET wta.base_transaction_value = -1*(l_wta_temp_value)
4158: WHERE transaction_id in (p_wip_txn_id)
4159: AND (base_transaction_value < 0
4160: and cost_element_id=(SELECT MAX(cost_element_id)
4161: FROM wip_transaction_accounts wta1
4162: WHERE wta1.transaction_id = p_wip_txn_id
4163: AND wta1.base_transaction_value < 0 ));
4164: ELSIF (p_txn_type = 2) THEN
4165:

Line 4169: FROM wip_transaction_accounts wta

4165:
4166: l_stmt_num := 160;
4167: SELECT sum(base_transaction_value)
4168: INTO l_wta_temp_value
4169: FROM wip_transaction_accounts wta
4170: WHERE transaction_id in (p_wip_txn_id)
4171: AND NOT ( cost_element_id = (SELECT MAX(cost_element_id)
4172: FROM wip_transaction_accounts wta1
4173: WHERE wta1.transaction_id = p_wip_txn_id

Line 4172: FROM wip_transaction_accounts wta1

4168: INTO l_wta_temp_value
4169: FROM wip_transaction_accounts wta
4170: WHERE transaction_id in (p_wip_txn_id)
4171: AND NOT ( cost_element_id = (SELECT MAX(cost_element_id)
4172: FROM wip_transaction_accounts wta1
4173: WHERE wta1.transaction_id = p_wip_txn_id
4174: AND wta1.base_transaction_value > 0)
4175: AND base_transaction_value > 0);
4176:

Line 4178: UPDATE wip_transaction_accounts wta

4174: AND wta1.base_transaction_value > 0)
4175: AND base_transaction_value > 0);
4176:
4177: l_stmt_num := 170;
4178: UPDATE wip_transaction_accounts wta
4179: SET wta.base_transaction_value = -1*(l_wta_temp_value)
4180: WHERE transaction_id in (p_wip_txn_id)
4181: AND (base_transaction_value > 0
4182: and cost_element_id=(SELECT MAX(cost_element_id)

Line 4183: FROM wip_transaction_accounts wta1

4179: SET wta.base_transaction_value = -1*(l_wta_temp_value)
4180: WHERE transaction_id in (p_wip_txn_id)
4181: AND (base_transaction_value > 0
4182: and cost_element_id=(SELECT MAX(cost_element_id)
4183: FROM wip_transaction_accounts wta1
4184: WHERE wta1.transaction_id = p_wip_txn_id));
4185: ELSIF p_txn_type in (4,6) THEN
4186: l_stmt_num := 180;
4187: SELECT sum(base_transaction_value)

Line 4189: FROM wip_transaction_accounts

4185: ELSIF p_txn_type in (4,6) THEN
4186: l_stmt_num := 180;
4187: SELECT sum(base_transaction_value)
4188: INTO l_wta_temp_value
4189: FROM wip_transaction_accounts
4190: WHERE transaction_id in (p_wip_txn_id)
4191: AND base_transaction_value > 0;
4192:
4193: l_stmt_num := 190;

Line 4194: UPDATE wip_transaction_accounts wta

4190: WHERE transaction_id in (p_wip_txn_id)
4191: AND base_transaction_value > 0;
4192:
4193: l_stmt_num := 190;
4194: UPDATE wip_transaction_accounts wta
4195: SET base_transaction_value = -1 * (l_wta_temp_value)
4196: WHERE wta.transaction_id = p_wip_txn_id
4197: AND wta.cost_element_id is null;
4198: END IF; -- end handling different cases for different transaction types

Line 4359: FROM wip_transaction_accounts

4355: FROM wip_entities we
4356: WHERE we.wip_entity_id = p_wip_entity_id
4357: AND exists
4358: ( SELECT null
4359: FROM wip_transaction_accounts
4360: WHERE transaction_id = p_wip_txn_id);
4361:
4362: l_rows_inserted := SQL%ROWCOUNT;
4363: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN

Line 4609: INSERT INTO WIP_TRANSACTION_ACCOUNTS

4605: FND_FILE.put_line(FND_FILE.LOG,'CSTPSMUT.INSERT_WIP_TXN_ACCT: wip_txn_id: '|| p_wip_txn_id);
4606: END IF;
4607:
4608: FOR c1 IN c_elements LOOP
4609: INSERT INTO WIP_TRANSACTION_ACCOUNTS
4610: (
4611: TRANSACTION_ID, REFERENCE_ACCOUNT, LAST_UPDATE_DATE,
4612: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
4613: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 4649: UPDATE WIP_TRANSACTION_ACCOUNTS

4645: 3,p_pl_res_cost,
4646: 4,p_pl_osp_cost,
4647: 5,p_pl_ovh_cost)/p_min_acct_unit)*p_min_acct_unit <> 0;
4648:
4649: UPDATE WIP_TRANSACTION_ACCOUNTS
4650: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
4651: WHERE TRANSACTION_ID = p_wip_txn_id;
4652: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
4653: END LOOP;

Line 4658: || 'into wip_transaction_accounts.'

4654:
4655: IF (l_rows_inserted > 0) and (p_debug = 'Y') THEN
4656: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4657: || 'row(s) inserted '
4658: || 'into wip_transaction_accounts.'
4659: || ', wip_entity_id: '
4660: || p_wip_id);
4661: END IF;
4662:

Line 4778: INSERT INTO WIP_TRANSACTION_ACCOUNTS

4774: l_stmt_num := 10;
4775: p_err_num := 0;
4776:
4777:
4778: INSERT INTO WIP_TRANSACTION_ACCOUNTS
4779: (
4780: TRANSACTION_ID, REFERENCE_ACCOUNT, LAST_UPDATE_DATE,
4781: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
4782: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 4797: UPDATE WIP_TRANSACTION_ACCOUNTS

4793: FROM wsm_sm_resulting_jobs res
4794: WHERE res.transaction_id = p_sm_txn_id
4795: HAVING NVL(ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit,0) <> 0;
4796:
4797: UPDATE WIP_TRANSACTION_ACCOUNTS
4798: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
4799: WHERE TRANSACTION_ID = p_wip_txn_id;
4800: l_rows_inserted := SQL%ROWCOUNT;
4801: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN

Line 4803: 'into wip_transaction_accounts.');

4799: WHERE TRANSACTION_ID = p_wip_txn_id;
4800: l_rows_inserted := SQL%ROWCOUNT;
4801: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4802: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted) || 'row(s) inserted ' ||
4803: 'into wip_transaction_accounts.');
4804: END IF;
4805: END BONUS_WIP_TXN_ACCT;
4806:
4807:

Line 4892: FROM wip_transaction_accounts wta

4888: -wta.base_transaction_value, 0)), 0),
4889: nvl(wpb.tl_overhead_out, 0) +
4890: nvl(SUM(DECODE(wta.cost_element_id,5,
4891: -wta.base_transaction_value, 0)), 0)
4892: FROM wip_transaction_accounts wta
4893: WHERE wta.transaction_id = p_sl_wip_txn_id
4894: AND wta.wip_entity_id = p_sl_wip_id)
4895: -- AND wta.accounting_line_type <> 31)
4896: WHERE wpb.wip_entity_id = p_sl_wip_id

Line 4900: FROM wip_transaction_accounts

4896: WHERE wpb.wip_entity_id = p_sl_wip_id
4897: AND wpb.acct_period_id = p_acct_period_id
4898: AND exists
4899: ( SELECT null
4900: FROM wip_transaction_accounts
4901: WHERE transaction_id = p_sl_wip_txn_id);
4902:
4903: l_rows_inserted := SQL%ROWCOUNT;
4904: -- dbms_output.put_line(to_char(l_rows_inserted) || 'row(s) updated ' ||

Line 5013: FROM wip_transaction_accounts wta

5009: wta.base_transaction_value, 0)), 0),
5010: nvl(wpb.tl_overhead_in, 0) +
5011: nvl(SUM(DECODE(wta.cost_element_id,5,
5012: wta.base_transaction_value, 0)), 0)
5013: FROM wip_transaction_accounts wta
5014: WHERE wta.transaction_id = p_rl_wip_txn_id
5015: AND wta.wip_entity_id = p_rl_wip_id)
5016: -- AND wta.accounting_line_type <> 31)
5017: WHERE wpb.wip_entity_id = p_rl_wip_id

Line 5021: FROM wip_transaction_accounts

5017: WHERE wpb.wip_entity_id = p_rl_wip_id
5018: AND wpb.acct_period_id = p_acct_period_id
5019: AND exists
5020: ( SELECT null
5021: FROM wip_transaction_accounts
5022: WHERE transaction_id = p_rl_wip_txn_id);
5023:
5024: l_rows_inserted := SQL%ROWCOUNT;
5025: