DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on CST_QUANTITY_LAYERS

Line 4483: UPDATE cst_quantity_layers

4479: WHERE organization_id = P_Org_Id
4480: AND inventory_item_id = p_Item_Id
4481: AND cost_type_id = l_prim_cost_method;
4482:
4483: UPDATE cst_quantity_layers
4484: SET LAST_UPDATED_BY = P_Last_Updated_By
4485: ,LAST_UPDATE_DATE = SYSDATE
4486: ,LAST_UPDATE_LOGIN = P_Last_Updated_Login
4487: ,PL_MATERIAL = 0

Line 4526: FROM cst_quantity_layers

4522: /* AND l_profile_exists AND (l_profile_val = '2')) Bug 4247149*/
4523: THEN
4524: DELETE cst_layer_cost_details
4525: WHERE layer_id IN ( SELECT layer_id
4526: FROM cst_quantity_layers
4527: WHERE inventory_item_id = P_Item_Id
4528: AND organization_id = P_Org_Id );
4529: IF (l_prim_cost_method IN (5,6)) THEN
4530: CSTPLENG.update_inv_layer_cost(