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 933: * Insert into mtl_cst_txn_cost_details now that the *

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

Line 946: INSERT INTO mtl_cst_txn_cost_details

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

Line 999: INSERT INTO mtl_cst_txn_cost_details

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

Line 1054: INSERT INTO mtl_cst_txn_cost_details

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

Line 1358: INSERT INTO mtl_cst_txn_cost_details

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

Line 1873: INSERT INTO mtl_cst_txn_cost_details

1869:
1870:
1871: l_stmt_num := 140;
1872:
1873: INSERT INTO mtl_cst_txn_cost_details
1874: (
1875: TRANSACTION_ID,
1876: ORGANIZATION_ID,
1877: INVENTORY_ITEM_ID,

Line 1925: INSERT INTO mtl_cst_txn_cost_details

1921: sum(nvl(wrocd.temp_relieved_value,0)) <> 0;
1922:
1923: l_stmt_num := 150;
1924:
1925: INSERT INTO mtl_cst_txn_cost_details
1926: (
1927: TRANSACTION_ID,
1928: ORGANIZATION_ID,
1929: INVENTORY_ITEM_ID,

Line 1980: INSERT INTO mtl_cst_txn_cost_details

1976: sum(nvl(wor.temp_relieved_value,0)) <> 0;
1977:
1978: l_stmt_num := 160;
1979:
1980: INSERT INTO mtl_cst_txn_cost_details
1981: (
1982: TRANSACTION_ID,
1983: ORGANIZATION_ID,
1984: INVENTORY_ITEM_ID,