[Home] [Help]
423: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/
424: oe_order_headers_all OOHA, /* of the layer cost worker*/
425: mtl_sales_orders MSO,
426: mtl_material_transactions MMT,
427: mtl_cst_actual_cost_details MCACD,
428: cst_cogs_events CCE /*Bug Fix 16766955*/
429: WHERE OOLA.line_id = l_so_line_id
430: AND OOHA.header_id = OOLA.header_id
431: AND MSO.segment1 = TO_CHAR(OOHA.order_number) -- extraneous MSOs are possible
486: FROM oe_order_lines_all OOLA, /*BUG 5768680 Changes introduced to improve performance*/
487: oe_order_headers_all OOHA, /* of the layer cost worker*/
488: mtl_sales_orders MSO,
489: mtl_material_transactions MMT,
490: mtl_cst_actual_cost_details MCACD
491: WHERE OOLA.line_id = l_so_line_id
492: AND OOHA.header_id = OOLA.header_id
493: AND MSO.segment1 = TO_CHAR(OOHA.order_number) -- extraneous MSOs are possible
494: AND MMT.transaction_source_id = MSO.sales_order_id
1387: end if;
1388:
1389: /***********************************************************************
1390: ** In the following conditions we will be doing distribution for the **
1391: ** standard org, so need populate mtl_cst_actual_cost_details with **
1392: ** the standard costs. **
1393: ** 1. intransit interorg and one of the orgs is standard. **
1394: ** 2. direct interorg and the txn_org_id is standard. **
1395: ***********************************************************************/
1435: /* If no rows exist in cicd (item hasn't been costed), insert into */
1436: /* mcacd using 0 value of this level material */
1437: if (l_count > 0) then
1438: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using cost from CICD');
1439: insert into mtl_cst_actual_cost_details (
1440: transaction_id,
1441: organization_id,
1442: layer_id,
1443: cost_element_id,
1488: and inventory_item_id = i_item_id
1489: group by cost_element_id, level_type;
1490: else
1491: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using 0 cost');
1492: insert into mtl_cst_actual_cost_details (
1493: transaction_id,
1494: organization_id,
1495: layer_id,
1496: cost_element_id,
1629: i_prg_appl_id,
1630: i_prg_id,
1631: sysdate,
1632: nvl(sum(actual_cost),0)
1633: from mtl_cst_actual_cost_details cacd
1634: where cacd.transaction_id = i_txn_id
1635: and cacd.organization_id = l_std_org
1636: and cacd.layer_id = -1)
1637: where mmt.transaction_id = i_txn_id;
1962: l_stmt_num := 210;
1963: -- if the receiving org is std exp, copy the txn info
1964: -- into MCACD from MCTCD.
1965:
1966: insert into mtl_cst_actual_cost_details (
1967: transaction_id,
1968: organization_id,
1969: layer_id,
1970: cost_element_id,
2033: i_prg_appl_id,
2034: i_prg_id,
2035: sysdate,
2036: nvl(sum(actual_cost),0)
2037: from mtl_cst_actual_cost_details cacd
2038: where cacd.transaction_id = l_txn_update_id
2039: and cacd.organization_id = l_std_org
2040: and cacd.layer_id = -1)
2041: where mmt.transaction_id = l_txn_update_id;
2071:
2072: if (l_txfr_std_exp = 1) then
2073: l_stmt_num := 260;
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_txfr_std_exp = 1');
2075: insert into mtl_cst_actual_cost_details (
2076: transaction_id,
2077: organization_id,
2078: layer_id,
2079: cost_element_id,
2140: i_prg_appl_id,
2141: i_prg_id,
2142: sysdate,
2143: nvl(sum(actual_cost),0)
2144: from mtl_cst_actual_cost_details cacd
2145: where cacd.transaction_id = l_txn_update_id
2146: and cacd.organization_id = l_std_org
2147: and cacd.layer_id = -1)
2148: where mmt.transaction_id = l_txn_update_id;
2166: end if;
2167:
2168: l_stmt_num := 270;
2169: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_to_std_exp = 1');
2170: insert into mtl_cst_actual_cost_details (
2171: transaction_id,
2172: organization_id,
2173: layer_id,
2174: cost_element_id,
2237: i_prg_appl_id,
2238: i_prg_id,
2239: sysdate,
2240: nvl(sum(actual_cost),0)
2241: from mtl_cst_actual_cost_details cacd
2242: where cacd.transaction_id = l_txn_update_id
2243: and cacd.organization_id = l_std_org
2244: and cacd.layer_id = -1)
2245: where mmt.transaction_id = l_txn_update_id;
2813: mcacd.actual_cost,
2814: mcacd.prior_cost,
2815: mcacd.new_cost,
2816: mcacd.layer_id
2817: from mtl_cst_actual_cost_details mcacd
2818: where mcacd.transaction_id = c_transaction_id
2819: and mcacd.layer_id = i_to_layer;
2820:
2821: type t_cst_element is table of number
3225:
3226: l_stmt_num := 80;
3227:
3228: if l_inv_layer_id = 0 then -- no layer cost
3229: insert into mtl_cst_actual_cost_details(
3230: transaction_id,
3231: organization_id,
3232: layer_id,
3233: cost_element_id,
3272: 'N',
3273: 0,
3274: 'N');
3275: else -- has layer cost
3276: insert into mtl_cst_actual_cost_details(
3277: transaction_id,
3278: organization_id,
3279: layer_id,
3280: cost_element_id,
3614:
3615: l_stmt_num := 100;
3616:
3617: if (l_exp_item = 0 and l_layer_chg = 1 and l_to_exp = 1 and i_hook = 0) then
3618: insert into mtl_cst_actual_cost_details(
3619: transaction_id,
3620: organization_id,
3621: layer_id,
3622: cost_element_id,
3660: mcacd.actual_cost,
3661: 'N',
3662: 0,
3663: 'N'
3664: from mtl_cst_actual_cost_details mcacd
3665: where transaction_id = i_txn_id
3666: and organization_id = i_org_id
3667: and layer_id = l_from_layer;
3668:
3721: i_prg_id,
3722: sysdate,
3723: i_item_id,
3724: mcacd.actual_cost
3725: from mtl_cst_actual_cost_details mcacd
3726: where transaction_id = i_txn_id
3727: and organization_id = i_org_id
3728: and layer_id = l_from_layer;
3729:
4012: SUM(NVL(mcacd.actual_cost, 0)),
4013: SUM(NVL(mcacd.prior_cost, 0)),
4014: SUM(NVL(mcacd.new_cost, 0)),
4015: SUM(NVL(mcacd.variance_amount, 0))
4016: from mtl_cst_actual_cost_details mcacd
4017: where mcacd.transaction_id = i_txn_id
4018: and mcacd.layer_id = l_to_layer)
4019: where mmt1.transaction_id = l_txf_txn_id
4020: and mmt1.primary_quantity > 0;