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.

[Home] [Help]

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 365: INSERT INTO mtl_pac_txn_cost_details (

361:
362: IF (l_already_processed >0) THEN
363: l_stmt_num := 77;
364: -- Use the PAC cost of the Sales Order Issue
365: INSERT INTO mtl_pac_txn_cost_details (
366: transaction_id,
367: pac_period_id,
368: cost_type_id,
369: cost_group_id,

Line 417: INSERT INTO mtl_pac_txn_cost_details (

413: ELSE
414: -- Create MPTCD for this cost-owned RMA receipt using the perpetual cost
415: l_stmt_num := 78;
416:
417: INSERT INTO mtl_pac_txn_cost_details (
418: transaction_id,
419: pac_period_id,
420: cost_type_id,
421: cost_group_id,

Line 476: -- instead of use mtl_pac_txn_cost_details

472: ELSIF (i_process_group = 2 AND i_txn_action_id = 27 AND i_txn_src_type_id = 12) THEN
473: -- If transaction has been already processed during first pass (i_process_group = 1)
474: -- then return without further processing
475: -- performance bug fix 6751847 fix: removed cst_pc_txn_history
476: -- instead of use mtl_pac_txn_cost_details
477: l_stmt_num := 79;
478: SELECT count(1)
479: INTO l_already_processed
480: FROM mtl_pac_txn_cost_details

Line 480: FROM mtl_pac_txn_cost_details

476: -- instead of use mtl_pac_txn_cost_details
477: l_stmt_num := 79;
478: SELECT count(1)
479: INTO l_already_processed
480: FROM mtl_pac_txn_cost_details
481: WHERE pac_period_id = i_pac_period_id
482: AND cost_group_id = i_cost_group_id
483: AND transaction_id = i_txn_id;
484:

Line 491: INSERT INTO mtl_pac_txn_cost_details (

487: END IF;
488:
489: ELSIF (i_process_group = 1) THEN
490: l_stmt_num := 80;
491: INSERT INTO mtl_pac_txn_cost_details (
492: transaction_id,
493: pac_period_id,
494: cost_type_id,
495: cost_group_id,

Line 1207: INSERT INTO mtl_pac_txn_cost_details (

1203: --INVCONV sikhanna
1204: -- From organization is a process org. just get transaction cost
1205: -- trp cost and conv rate is selected in the begining itself
1206:
1207: INSERT INTO mtl_pac_txn_cost_details (
1208: transaction_id,
1209: pac_period_id,
1210: cost_type_id,
1211: cost_group_id,

Line 1261: INSERT INTO mtl_pac_txn_cost_details (

1257: END IF;
1258:
1259: ELSE -- Earn MOH in all other cases
1260:
1261: INSERT INTO mtl_pac_txn_cost_details (
1262: transaction_id,
1263: pac_period_id,
1264: cost_type_id,
1265: cost_group_id,

Line 1498: FROM mtl_pac_txn_cost_details

1494: l_stmt_num := 10;
1495:
1496: SELECT count(*)
1497: INTO l_elem_cnt
1498: FROM mtl_pac_txn_cost_details
1499: WHERE transaction_id = I_TXN_ID
1500: AND pac_period_id = I_PAC_PERIOD_ID
1501: AND cost_type_id = I_COST_TYPE_ID
1502: AND cost_group_id = I_COST_GROUP_ID

Line 1510: UPDATE MTL_PAC_TXN_COST_DETAILS

1506: IF l_elem_cnt > 0 THEN
1507:
1508: l_stmt_num := 20;
1509:
1510: UPDATE MTL_PAC_TXN_COST_DETAILS
1511: SET transaction_cost = (transaction_cost + i_incr_cost)
1512: WHERE transaction_id = I_TXN_ID
1513: AND pac_period_id = I_PAC_PERIOD_ID
1514: AND cost_type_id = I_COST_TYPE_ID

Line 1620: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1616:
1617: l_stmt_num := 10;
1618:
1619:
1620: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1621: transaction_id,
1622: pac_period_id,
1623: cost_type_id,
1624: cost_group_id,

Line 1742: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1738: END;
1739:
1740: l_stmt_num := 20;
1741:
1742: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1743: transaction_id,
1744: pac_period_id,
1745: cost_type_id,
1746: cost_group_id,

Line 1897: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

1893: /* Prior period exists */
1894:
1895: l_stmt_num := 40;
1896:
1897: INSERT INTO MTL_PAC_TXN_COST_DETAILS (
1898: transaction_id,
1899: pac_period_id,
1900: cost_type_id,
1901: cost_group_id,

Line 2063: INSERT INTO mtl_pac_txn_cost_details (

2059: END IF;
2060:
2061: IF l_perp_ship_cost <> 0 THEN
2062: /* Insert all cost elements */
2063: INSERT INTO mtl_pac_txn_cost_details (
2064: transaction_id,
2065: pac_period_id,
2066: cost_type_id,
2067: cost_group_id,

Line 2558: INSERT INTO mtl_pac_txn_cost_details (

2554:
2555:
2556: l_stmt_num := 60;
2557:
2558: INSERT INTO mtl_pac_txn_cost_details (
2559: transaction_id,
2560: pac_period_id,
2561: cost_type_id,
2562: cost_group_id,

Line 2647: FROM mtl_pac_txn_cost_details

2643: transaction_cost,
2644: 'Y',
2645: 'N',
2646: sysdate
2647: FROM mtl_pac_txn_cost_details
2648: WHERE transaction_id = i_txn_id
2649: AND pac_period_id = i_pac_period_id
2650: AND cost_group_id = i_cost_group_id;
2651: