APPS.CSTPACIT dependencies on MTL_CST_TXN_COST_DETAILS

Line 385: INSERT INTO MTL_CST_TXN_COST_DETAILS (

381: end if;
382:
383: if (l_layer_id <> 0) then
384:
385: INSERT INTO MTL_CST_TXN_COST_DETAILS (
386: TRANSACTION_ID,
387: ORGANIZATION_ID,
388: INVENTORY_ITEM_ID,
389: COST_ELEMENT_ID,

Line 431: UPDATE MTL_CST_TXN_COST_DETAILS mctcd

427: sysdate
428: FROM CST_LAYER_COST_DETAILS CLCD
429: WHERE CLCD.LAYER_ID = l_layer_id;
430:
431: UPDATE MTL_CST_TXN_COST_DETAILS mctcd
432: set (VALUE_CHANGE,
433: PERCENTAGE_CHANGE,
434: NEW_AVERAGE_COST)
435: =

Line 455: INSERT INTO MTL_CST_TXN_COST_DETAILS (

451: and mtcdi.level_type = mctcd.level_type
452: and mtcdi.cost_element_id = mctcd.cost_element_id);
453: /*Added for Bug#2509196*/
454:
455: INSERT INTO MTL_CST_TXN_COST_DETAILS (
456: TRANSACTION_ID,
457: ORGANIZATION_ID,
458: INVENTORY_ITEM_ID,
459: COST_ELEMENT_ID,

Line 498: from mtl_cst_txn_cost_details mctcd1

494: FROM MTL_TXN_COST_DET_INTERFACE MTCDI
495: WHERE mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
496: and ( (MTCDI.cost_element_id, MTCDI.level_type) not in
497: (select mctcd1.cost_element_id,mctcd1.level_type
498: from mtl_cst_txn_cost_details mctcd1
499: where mctcd1.transaction_id=i_txn_id
500: )
501: );
502: /*End of Addition for Bug#2509196*/

Line 508: /*INSERT INTO MTL_CST_TXN_COST_DETAILS (

504: /* Changed the following for Bug#2509196 as follows so as to
505: take the elemental details from mtcdi*/
506: /* No layer exists , hence use THIS level MATERIAL row */
507:
508: /*INSERT INTO MTL_CST_TXN_COST_DETAILS (
509: TRANSACTION_ID,
510: ORGANIZATION_ID,
511: INVENTORY_ITEM_ID,
512: COST_ELEMENT_ID,

Line 547: INSERT INTO MTL_CST_TXN_COST_DETAILS (

543: i_request_id,
544: i_prog_appl_id,
545: i_prog_id,
546: sysdate);*/
547: INSERT INTO MTL_CST_TXN_COST_DETAILS (
548: TRANSACTION_ID,
549: ORGANIZATION_ID,
550: INVENTORY_ITEM_ID,
551: COST_ELEMENT_ID,

Line 672: * insert each elements into MTL_CST_TXN_COST_DETAILS.

668: raise cost_det_new_insert_error;
669: end if;
670:
671: /* If layer detail exist, then calculate proportional costs and
672: * insert each elements into MTL_CST_TXN_COST_DETAILS.
673: */
674:
675: if (l_layer_id <> 0) then
676:

Line 718: INSERT INTO MTL_CST_TXN_COST_DETAILS (

714: FROM CST_LAYER_COST_DETAILS
715: WHERE LAYER_ID = l_layer_id;
716: end if;
717:
718: INSERT INTO MTL_CST_TXN_COST_DETAILS (
719: TRANSACTION_ID,
720: ORGANIZATION_ID,
721: INVENTORY_ITEM_ID,
722: COST_ELEMENT_ID,

Line 781: INSERT INTO MTL_CST_TXN_COST_DETAILS (

777: raise cost_det_new_insert_error;
778: end if;
779:
780:
781: INSERT INTO MTL_CST_TXN_COST_DETAILS (
782: TRANSACTION_ID,
783: ORGANIZATION_ID,
784: INVENTORY_ITEM_ID,
785: COST_ELEMENT_ID,