[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,
2777:
2778: END IF; -- Main If ends here.
2779:
2780: /************************************************************
2781: * Insert into mtl_cst_txn_cost_details now that the *
2782: * Costs have been computed ... *
2783: * 3 statements are required --> one each for PL costs *
2784: * , TL Res/OSP costs and TL ovhd costs. *
2785: * Remember - the cst_txn_cost_detail tables stores unit *
2797: IF (i_final_comp_flag='Y') THEN
2798: stmt_num := 350;
2799: /* Bug 7346243: Removed Variance value from Available
2800: Value for Final Completion */
2801: INSERT INTO mtl_cst_txn_cost_details
2802: (
2803: TRANSACTION_ID,
2804: ORGANIZATION_ID,
2805: INVENTORY_ITEM_ID,
2859:
2860: stmt_num := 355;
2861: /* Bug 7346243: Removed Variance value from Available
2862: Value for Final Completion */
2863: INSERT INTO mtl_cst_txn_cost_details
2864: (
2865: TRANSACTION_ID,
2866: ORGANIZATION_ID,
2867: INVENTORY_ITEM_ID,
2920:
2921: ELSE
2922: stmt_num := 360;
2923:
2924: INSERT INTO mtl_cst_txn_cost_details
2925: (
2926: TRANSACTION_ID,
2927: ORGANIZATION_ID,
2928: INVENTORY_ITEM_ID,
2970:
2971:
2972: stmt_num := 370;
2973:
2974: INSERT INTO mtl_cst_txn_cost_details
2975: (
2976: TRANSACTION_ID,
2977: ORGANIZATION_ID,
2978: INVENTORY_ITEM_ID,
3022: HAVING sum(nvl(wor.temp_relieved_value,0)) <> 0;
3023:
3024: stmt_num := 390;
3025:
3026: INSERT INTO mtl_cst_txn_cost_details
3027: (
3028: TRANSACTION_ID,
3029: ORGANIZATION_ID,
3030: INVENTORY_ITEM_ID,
3085: ---------------------------------------------
3086: stmt_num := 410;
3087: SELECT count(*)
3088: INTO l_count
3089: FROM mtl_cst_txn_cost_details mctcd,
3090: mtl_material_transactions mmt
3091: WHERE mctcd.transaction_id = mmt.transaction_id
3092: AND mctcd.transaction_id = i_trx_id
3093: AND mctcd.transaction_cost < 0;
3320: NULL, NULL,
3321: NULL,
3322: i_request_id, i_prog_appl_id,
3323: i_prog_id, sysdate
3324: FROM mtl_cst_txn_cost_details mctcd,
3325: mtl_material_transactions mmt,
3326: wip_discrete_jobs wdj,
3327: fnd_currencies c1
3328: WHERE mctcd.transaction_id = mmt.transaction_id
3384: NULL, NULL,
3385: NULL,
3386: i_request_id, i_prog_appl_id,
3387: i_prog_id, sysdate
3388: FROM mtl_cst_txn_cost_details mctcd,
3389: mtl_material_transactions mmt,
3390: wip_discrete_jobs wdj,
3391: fnd_currencies c1
3392: WHERE mctcd.transaction_id = mmt.transaction_id
3440: NULL, NULL,
3441: NULL,
3442: i_request_id, i_prog_appl_id,
3443: i_prog_id, sysdate
3444: FROM mtl_cst_txn_cost_details mctcd,
3445: mtl_material_transactions mmt,
3446: wip_discrete_jobs wdj,
3447: fnd_currencies c1
3448: WHERE mctcd.transaction_id = mmt.transaction_id
3597: 1,decode(cost_element_id,
3598: 5,nvl(transaction_cost,0)
3599: ,0),0)))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)
3600: FROM
3601: mtl_cst_txn_cost_details mctcd,
3602: fnd_currencies c1
3603: WHERE transaction_id = i_trx_id
3604: AND transaction_cost < 0
3605: AND c1.currency_code = l_pri_curr
3612: stmt_num := 510;
3613: --
3614: -- We have to re-avg with 0 cost but not -ve cost
3615: --
3616: UPDATE mtl_cst_txn_cost_details
3617: SET transaction_cost = 0
3618: WHERE transaction_cost < 0
3619: AND transaction_id = i_trx_id;
3620:
3801: l_insert_ind := 1;
3802:
3803: stmt_num := 70;
3804:
3805: INSERT INTO mtl_cst_txn_cost_details
3806: (
3807: TRANSACTION_ID,
3808: ORGANIZATION_ID,
3809: INVENTORY_ITEM_ID,
3871: l_insert_ind := 1;
3872:
3873: stmt_num := 80;
3874:
3875: INSERT INTO mtl_cst_txn_cost_details
3876: (
3877: TRANSACTION_ID,
3878: ORGANIZATION_ID,
3879: INVENTORY_ITEM_ID,
4430:
4431: END IF;
4432:
4433: /************************************************************
4434: * Insert into mtl_cst_txn_cost_details now that the *
4435: * Costs have been computed ... *
4436: * 3 statements are required --> one each for PL costs *
4437: * , TL Res/OSP costs and TL ovhd costs. *
4438: * Remember - the cst_txn_cost_detail tables stores unit *
4446: IF (l_insert_ind <>1) THEN
4447:
4448: stmt_num := 270;
4449:
4450: INSERT INTO mtl_cst_txn_cost_details
4451: (
4452: TRANSACTION_ID,
4453: ORGANIZATION_ID,
4454: INVENTORY_ITEM_ID,
4495: HAVING sum(nvl(wrocd.temp_relieved_value,0)) <> 0;
4496:
4497: stmt_num := 290;
4498:
4499: INSERT INTO mtl_cst_txn_cost_details
4500: (
4501: TRANSACTION_ID,
4502: ORGANIZATION_ID,
4503: INVENTORY_ITEM_ID,
4547: HAVING sum(nvl(wor.temp_relieved_value,0)) <> 0;
4548:
4549: stmt_num := 310;
4550:
4551: INSERT INTO mtl_cst_txn_cost_details
4552: (
4553: TRANSACTION_ID,
4554: ORGANIZATION_ID,
4555: INVENTORY_ITEM_ID,