DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on CST_QUANTITY_LAYERS

Line 4748: UPDATE cst_quantity_layers

4744: WHERE organization_id = P_Org_Id
4745: AND inventory_item_id = p_Item_Id
4746: AND cost_type_id = l_prim_cost_method;
4747:
4748: UPDATE cst_quantity_layers
4749: SET LAST_UPDATED_BY = P_Last_Updated_By
4750: ,LAST_UPDATE_DATE = SYSDATE
4751: ,LAST_UPDATE_LOGIN = P_Last_Updated_Login
4752: ,PL_MATERIAL = 0

Line 4791: FROM cst_quantity_layers

4787: /* AND l_profile_exists AND (l_profile_val = '2')) Bug 4247149*/
4788: THEN
4789: DELETE cst_layer_cost_details
4790: WHERE layer_id IN ( SELECT layer_id
4791: FROM cst_quantity_layers
4792: WHERE inventory_item_id = P_Item_Id
4793: AND organization_id = P_Org_Id );
4794: IF (l_prim_cost_method IN (5,6)) THEN
4795: CSTPLENG.update_inv_layer_cost(