[Home] [Help]
738:
739: /*----------------------------------------------------------
740: | Set the insert indicator to ensure that we skip the insert
741: | into cst_txn_cst_details at the end of the file.
742: | Then insert into mtl_cst_txn_cost_details in 2 passes,
743: | one for PL costs and one for TL costs ...
744: |-----------------------------------------------------------*/
745:
746:
753:
754: stmt_num := 135;
755: /* Bug 7346243: Removed Variance value from Available
756: Value for Final Completion */
757: INSERT INTO mtl_cst_txn_cost_details
758: (
759: TRANSACTION_ID,
760: ORGANIZATION_ID,
761: INVENTORY_ITEM_ID,
815: 5,sum(nvl(tl_overhead_in,0)-nvl(tl_overhead_out,0)-nvl(tl_overhead_var,0))) > 0;
816:
817: stmt_num := 150;
818:
819: INSERT INTO mtl_cst_txn_cost_details
820: (
821: TRANSACTION_ID,
822: ORGANIZATION_ID,
823: INVENTORY_ITEM_ID,
1130:
1131:
1132: stmt_num := 220;
1133:
1134: INSERT INTO mtl_cst_txn_cost_details
1135: (
1136: TRANSACTION_ID,
1137: ORGANIZATION_ID,
1138: INVENTORY_ITEM_ID,
1201: l_insert_ind := 1;
1202:
1203: stmt_num := 230;
1204:
1205: INSERT INTO mtl_cst_txn_cost_details
1206: (
1207: TRANSACTION_ID,
1208: ORGANIZATION_ID,
1209: INVENTORY_ITEM_ID,
2653:
2654: END IF; -- Main If ends here.
2655:
2656: /************************************************************
2657: * Insert into mtl_cst_txn_cost_details now that the *
2658: * Costs have been computed ... *
2659: * 3 statements are required --> one each for PL costs *
2660: * , TL Res/OSP costs and TL ovhd costs. *
2661: * Remember - the cst_txn_cost_detail tables stores unit *
2673: IF (i_final_comp_flag='Y') THEN
2674: stmt_num := 350;
2675: /* Bug 7346243: Removed Variance value from Available
2676: Value for Final Completion */
2677: INSERT INTO mtl_cst_txn_cost_details
2678: (
2679: TRANSACTION_ID,
2680: ORGANIZATION_ID,
2681: INVENTORY_ITEM_ID,
2729:
2730: stmt_num := 355;
2731: /* Bug 7346243: Removed Variance value from Available
2732: Value for Final Completion */
2733: INSERT INTO mtl_cst_txn_cost_details
2734: (
2735: TRANSACTION_ID,
2736: ORGANIZATION_ID,
2737: INVENTORY_ITEM_ID,
2784:
2785: ELSE
2786: stmt_num := 360;
2787:
2788: INSERT INTO mtl_cst_txn_cost_details
2789: (
2790: TRANSACTION_ID,
2791: ORGANIZATION_ID,
2792: INVENTORY_ITEM_ID,
2834:
2835:
2836: stmt_num := 370;
2837:
2838: INSERT INTO mtl_cst_txn_cost_details
2839: (
2840: TRANSACTION_ID,
2841: ORGANIZATION_ID,
2842: INVENTORY_ITEM_ID,
2886: HAVING sum(nvl(wor.temp_relieved_value,0)) <> 0;
2887:
2888: stmt_num := 390;
2889:
2890: INSERT INTO mtl_cst_txn_cost_details
2891: (
2892: TRANSACTION_ID,
2893: ORGANIZATION_ID,
2894: INVENTORY_ITEM_ID,
2949: ---------------------------------------------
2950: stmt_num := 410;
2951: SELECT count(*)
2952: INTO l_count
2953: FROM mtl_cst_txn_cost_details mctcd,
2954: mtl_material_transactions mmt
2955: WHERE mctcd.transaction_id = mmt.transaction_id
2956: AND mctcd.transaction_id = i_trx_id
2957: AND mctcd.transaction_cost < 0;
3178: NULL, NULL,
3179: NULL,
3180: i_request_id, i_prog_appl_id,
3181: i_prog_id, sysdate
3182: FROM mtl_cst_txn_cost_details mctcd,
3183: mtl_material_transactions mmt,
3184: wip_discrete_jobs wdj,
3185: fnd_currencies c1
3186: WHERE mctcd.transaction_id = mmt.transaction_id
3242: NULL, NULL,
3243: NULL,
3244: i_request_id, i_prog_appl_id,
3245: i_prog_id, sysdate
3246: FROM mtl_cst_txn_cost_details mctcd,
3247: mtl_material_transactions mmt,
3248: wip_discrete_jobs wdj,
3249: fnd_currencies c1
3250: WHERE mctcd.transaction_id = mmt.transaction_id
3298: NULL, NULL,
3299: NULL,
3300: i_request_id, i_prog_appl_id,
3301: i_prog_id, sysdate
3302: FROM mtl_cst_txn_cost_details mctcd,
3303: mtl_material_transactions mmt,
3304: wip_discrete_jobs wdj,
3305: fnd_currencies c1
3306: WHERE mctcd.transaction_id = mmt.transaction_id
3432: 1,decode(cost_element_id,
3433: 5,nvl(transaction_cost,0)
3434: ,0),0)))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)
3435: FROM
3436: mtl_cst_txn_cost_details mctcd,
3437: fnd_currencies c1
3438: WHERE transaction_id = i_trx_id
3439: AND transaction_cost < 0
3440: AND c1.currency_code = l_pri_curr
3447: stmt_num := 510;
3448: --
3449: -- We have to re-avg with 0 cost but not -ve cost
3450: --
3451: UPDATE mtl_cst_txn_cost_details
3452: SET transaction_cost = 0
3453: WHERE transaction_cost < 0
3454: AND transaction_id = i_trx_id;
3455:
3636: l_insert_ind := 1;
3637:
3638: stmt_num := 70;
3639:
3640: INSERT INTO mtl_cst_txn_cost_details
3641: (
3642: TRANSACTION_ID,
3643: ORGANIZATION_ID,
3644: INVENTORY_ITEM_ID,
3706: l_insert_ind := 1;
3707:
3708: stmt_num := 80;
3709:
3710: INSERT INTO mtl_cst_txn_cost_details
3711: (
3712: TRANSACTION_ID,
3713: ORGANIZATION_ID,
3714: INVENTORY_ITEM_ID,
4256:
4257: END IF;
4258:
4259: /************************************************************
4260: * Insert into mtl_cst_txn_cost_details now that the *
4261: * Costs have been computed ... *
4262: * 3 statements are required --> one each for PL costs *
4263: * , TL Res/OSP costs and TL ovhd costs. *
4264: * Remember - the cst_txn_cost_detail tables stores unit *
4272: IF (l_insert_ind <>1) THEN
4273:
4274: stmt_num := 270;
4275:
4276: INSERT INTO mtl_cst_txn_cost_details
4277: (
4278: TRANSACTION_ID,
4279: ORGANIZATION_ID,
4280: INVENTORY_ITEM_ID,
4321: HAVING sum(nvl(wrocd.temp_relieved_value,0)) <> 0;
4322:
4323: stmt_num := 290;
4324:
4325: INSERT INTO mtl_cst_txn_cost_details
4326: (
4327: TRANSACTION_ID,
4328: ORGANIZATION_ID,
4329: INVENTORY_ITEM_ID,
4373: HAVING sum(nvl(wor.temp_relieved_value,0)) <> 0;
4374:
4375: stmt_num := 310;
4376:
4377: INSERT INTO mtl_cst_txn_cost_details
4378: (
4379: TRANSACTION_ID,
4380: ORGANIZATION_ID,
4381: INVENTORY_ITEM_ID,