APPS.CSTPLCAC dependencies on MTL_CST_TXN_COST_DETAILS

Line 378: INSERT INTO mtl_cst_txn_cost_details

374: END IF;
375:
376: l_stmt_num := 110;
377:
378: INSERT INTO mtl_cst_txn_cost_details
379: (
380: TRANSACTION_ID,
381: ORGANIZATION_ID,
382: INVENTORY_ITEM_ID,

Line 931: * Insert into mtl_cst_txn_cost_details now that the *

927:
928:
929:
930: /************************************************************
931: * Insert into mtl_cst_txn_cost_details now that the *
932: * Costs have been computed ... *
933: * 3 statements are required --> one each for PL costs *
934: * , TL Res/OSP costs and TL ovhd costs. *
935: * Remember - the cst_txn_cost_detail tables stores unit *

Line 944: INSERT INTO mtl_cst_txn_cost_details

940:
941:
942: l_stmt_num := 210;
943:
944: INSERT INTO mtl_cst_txn_cost_details
945: (
946: TRANSACTION_ID,
947: ORGANIZATION_ID,
948: INVENTORY_ITEM_ID,

Line 997: INSERT INTO mtl_cst_txn_cost_details

993:
994:
995: l_stmt_num := 220;
996:
997: INSERT INTO mtl_cst_txn_cost_details
998: (
999: TRANSACTION_ID,
1000: ORGANIZATION_ID,
1001: INVENTORY_ITEM_ID,

Line 1052: INSERT INTO mtl_cst_txn_cost_details

1048: sum(nvl(wor.temp_relieved_value,0)) <> 0;
1049:
1050: l_stmt_num := 230;
1051:
1052: INSERT INTO mtl_cst_txn_cost_details
1053: (
1054: TRANSACTION_ID,
1055: ORGANIZATION_ID,
1056: INVENTORY_ITEM_ID,

Line 1355: INSERT INTO mtl_cst_txn_cost_details

1351: end if;
1352:
1353: IF ( l_comp_cost_source = 1 and l_use_val_cost_type = -1) THEN
1354: l_stmt_num :=35;
1355: INSERT INTO mtl_cst_txn_cost_details
1356: (
1357: TRANSACTION_ID,
1358: ORGANIZATION_ID,
1359: INVENTORY_ITEM_ID,

Line 1868: INSERT INTO mtl_cst_txn_cost_details

1864:
1865:
1866: l_stmt_num := 140;
1867:
1868: INSERT INTO mtl_cst_txn_cost_details
1869: (
1870: TRANSACTION_ID,
1871: ORGANIZATION_ID,
1872: INVENTORY_ITEM_ID,

Line 1920: INSERT INTO mtl_cst_txn_cost_details

1916: sum(nvl(wrocd.temp_relieved_value,0)) <> 0;
1917:
1918: l_stmt_num := 150;
1919:
1920: INSERT INTO mtl_cst_txn_cost_details
1921: (
1922: TRANSACTION_ID,
1923: ORGANIZATION_ID,
1924: INVENTORY_ITEM_ID,

Line 1975: INSERT INTO mtl_cst_txn_cost_details

1971: sum(nvl(wor.temp_relieved_value,0)) <> 0;
1972:
1973: l_stmt_num := 160;
1974:
1975: INSERT INTO mtl_cst_txn_cost_details
1976: (
1977: TRANSACTION_ID,
1978: ORGANIZATION_ID,
1979: INVENTORY_ITEM_ID,