DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on CST_ITEM_COSTS

Line 733: UPDATE CST_ITEM_COSTS A

729: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
730:
731: L_LOCATION := 1;
732:
733: UPDATE CST_ITEM_COSTS A
734: SET SHRINKAGE_RATE = DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE)
735: WHERE ORGANIZATION_ID = I_ORG_ID
736: AND COST_TYPE_ID = I_COST_TYPE_ID
737: AND EXISTS

Line 975: UPDATE CST_ITEM_COSTS A

971: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
972:
973: /* Changes for Bug #1768987. Setting shrinkage rate to 0 if shrinkage
974: rate is NULL in MSI. */
975: UPDATE CST_ITEM_COSTS A
976: SET SHRINKAGE_RATE = (
977: SELECT NVL(SHRINKAGE_RATE,0)
978: FROM MTL_SYSTEM_ITEMS
979: WHERE ORGANIZATION_ID = I_ORG_ID