[Home] [Help]
372: RETURN FALSE;
373: END valid_cost_group;
374:
375: -- Returns the default cost group from the organization or the subinventory
376: -- depending on whether the organization is standard costed or average costed
377: PROCEDURE proc_get_default_costgroup(p_organization_id IN NUMBER,
378: p_inventory_item_id IN NUMBER,
379: p_subinventory_code IN VARCHAR2,
380: p_locator_id IN NUMBER,
473: --2690948 Bug fix
474:
475: ELSE
476:
477: IF l_primary_cost_method = 1 THEN -- Standard costed org
478: BEGIN
479: SELECT default_cost_group_id
480: INTO x_cost_group_id
481: FROM mtl_secondary_inventories
1698: COMMON_ROUTING_SEQ_ID ,
1699: ORG_COST_GROUP_ID ,
1700: COST_TYPE_ID ,
1701: TRANSACTION_STATUS ,
1702: STANDARD_OPERATION_ID ,
1703: TASK_PRIORITY ,
1704: WMS_TASK_TYPE ,
1705: PARENT_LINE_ID ,
1706: LPN_ID ,
1932: p_mmtt_rec.COMMON_ROUTING_SEQ_ID ,
1933: p_mmtt_rec.ORG_COST_GROUP_ID ,
1934: p_mmtt_rec.COST_TYPE_ID ,
1935: p_mmtt_rec.TRANSACTION_STATUS ,
1936: p_mmtt_rec.STANDARD_OPERATION_ID ,
1937: p_mmtt_rec.TASK_PRIORITY ,
1938: p_mmtt_rec.WMS_TASK_TYPE ,
1939: p_mmtt_rec.PARENT_LINE_ID ,
1940: p_mmtt_rec.LPN_ID ,
3895: l_lot_number VARCHAR2(80); --- BUG#4291891 Joe DiIorio 04/08/2005
3896: l_transfer_cost_group_id NUMBER;
3897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3898: BEGIN
3899: -- Standard Start of API savepoint
3900:
3901: SAVEPOINT API_updatecostgroups;
3902: x_return_status := fnd_api.g_ret_sts_success;
3903: