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_PAC_TXN_COST_DETAILS

Line 283: INSERT INTO mtl_pac_txn_cost_details (

279: raise PROCESS_ERROR;
280: END IF;
281: end if;
282:
283: INSERT INTO mtl_pac_txn_cost_details (
284: transaction_id,
285: pac_period_id,
286: cost_type_id,
287: cost_group_id,

Line 322: UPDATE mtl_pac_txn_cost_details

318: i_login_id);
319:
320: ELSIF (i_process_group = 1 AND i_txn_action_id = 24) THEN
321:
322: UPDATE mtl_pac_txn_cost_details
323: SET pac_period_id = i_pac_period_id,
324: last_update_date = SYSDATE
325: WHERE transaction_id = i_txn_id
326: AND cost_type_id = i_cost_type_id

Line 387: INSERT INTO mtl_pac_txn_cost_details (

383:
384: IF (l_already_processed >0) THEN
385: l_stmt_num := 110;
386: -- Use the PAC cost of the Sales Order Issue
387: INSERT INTO mtl_pac_txn_cost_details (
388: transaction_id,
389: pac_period_id,
390: cost_type_id,
391: cost_group_id,

Line 444: INSERT INTO mtl_pac_txn_cost_details (

440: ELSE
441: -- Create MPTCD for this cost-owned RMA receipt using the perpetual cost
442: l_stmt_num := 120;
443:
444: INSERT INTO mtl_pac_txn_cost_details (
445: transaction_id,
446: pac_period_id,
447: cost_type_id,
448: cost_group_id,

Line 515: -- instead of use mtl_pac_txn_cost_details

511: ELSIF (i_process_group = 2 AND i_txn_action_id = 27 AND i_txn_src_type_id = 12) THEN
512: -- If transaction has been already processed during first pass (i_process_group = 1)
513: -- then return without further processing
514: -- performance bug fix 6751847 fix: removed cst_pc_txn_history
515: -- instead of use mtl_pac_txn_cost_details
516: l_stmt_num := 140;
517: SELECT count(1)
518: INTO l_already_processed
519: FROM mtl_pac_txn_cost_details

Line 519: FROM mtl_pac_txn_cost_details

515: -- instead of use mtl_pac_txn_cost_details
516: l_stmt_num := 140;
517: SELECT count(1)
518: INTO l_already_processed
519: FROM mtl_pac_txn_cost_details
520: WHERE pac_period_id = i_pac_period_id
521: AND cost_group_id = i_cost_group_id
522: AND transaction_id = i_txn_id;
523:

Line 530: INSERT INTO mtl_pac_txn_cost_details (

526: END IF;
527:
528: ELSIF (i_process_group = 1) THEN
529: l_stmt_num := 150;
530: INSERT INTO mtl_pac_txn_cost_details (
531: transaction_id,
532: pac_period_id,
533: cost_type_id,
534: cost_group_id,

Line 1249: INSERT INTO mtl_pac_txn_cost_details (

1245: --INVCONV sikhanna
1246: -- From organization is a process org. just get transaction cost
1247: -- trp cost and conv rate is selected in the begining itself
1248:
1249: INSERT INTO mtl_pac_txn_cost_details (
1250: transaction_id,
1251: pac_period_id,
1252: cost_type_id,
1253: cost_group_id,

Line 1303: INSERT INTO mtl_pac_txn_cost_details (

1299: END IF;
1300:
1301: ELSE -- Earn MOH in all other cases
1302:
1303: INSERT INTO mtl_pac_txn_cost_details (
1304: transaction_id,
1305: pac_period_id,
1306: cost_type_id,
1307: cost_group_id,

Line 1540: FROM mtl_pac_txn_cost_details

1536: l_stmt_num := 10;
1537:
1538: SELECT count(*)
1539: INTO l_elem_cnt
1540: FROM mtl_pac_txn_cost_details
1541: WHERE transaction_id = I_TXN_ID
1542: AND pac_period_id = I_PAC_PERIOD_ID
1543: AND cost_type_id = I_COST_TYPE_ID
1544: AND cost_group_id = I_COST_GROUP_ID

Line 1552: UPDATE MTL_PAC_TXN_COST_DETAILS

1548: IF l_elem_cnt > 0 THEN
1549:
1550: l_stmt_num := 20;
1551:
1552: UPDATE MTL_PAC_TXN_COST_DETAILS
1553: SET transaction_cost = (transaction_cost + i_incr_cost)
1554: WHERE transaction_id = I_TXN_ID
1555: AND pac_period_id = I_PAC_PERIOD_ID
1556: AND cost_type_id = I_COST_TYPE_ID

Line 1662: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1658:
1659: l_stmt_num := 10;
1660:
1661:
1662: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1663: transaction_id,
1664: pac_period_id,
1665: cost_type_id,
1666: cost_group_id,

Line 1784: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1780: END;
1781:
1782: l_stmt_num := 20;
1783:
1784: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1785: transaction_id,
1786: pac_period_id,
1787: cost_type_id,
1788: cost_group_id,

Line 1939: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1935: /* Prior period exists */
1936:
1937: l_stmt_num := 40;
1938:
1939: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1940: transaction_id,
1941: pac_period_id,
1942: cost_type_id,
1943: cost_group_id,

Line 2105: INSERT INTO mtl_pac_txn_cost_details (

2101: END IF;
2102:
2103: IF l_perp_ship_cost <> 0 THEN
2104: /* Insert all cost elements */
2105: INSERT INTO mtl_pac_txn_cost_details (
2106: transaction_id,
2107: pac_period_id,
2108: cost_type_id,
2109: cost_group_id,

Line 2600: INSERT INTO mtl_pac_txn_cost_details (

2596:
2597:
2598: l_stmt_num := 60;
2599:
2600: INSERT INTO mtl_pac_txn_cost_details (
2601: transaction_id,
2602: pac_period_id,
2603: cost_type_id,
2604: cost_group_id,

Line 2689: FROM mtl_pac_txn_cost_details

2685: transaction_cost,
2686: 'Y',
2687: 'N',
2688: sysdate
2689: FROM mtl_pac_txn_cost_details
2690: WHERE transaction_id = i_txn_id
2691: AND pac_period_id = i_pac_period_id
2692: AND cost_group_id = i_cost_group_id;
2693: