DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on CST_ITEM_COSTS

Line 669: UPDATE CST_ITEM_COSTS A

665: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
666:
667: L_LOCATION := 1;
668:
669: UPDATE CST_ITEM_COSTS A
670: SET SHRINKAGE_RATE = DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE)
671: WHERE ORGANIZATION_ID = I_ORG_ID
672: AND COST_TYPE_ID = I_COST_TYPE_ID
673: AND EXISTS

Line 911: UPDATE CST_ITEM_COSTS A

907: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
908:
909: /* Changes for Bug #1768987. Setting shrinkage rate to 0 if shrinkage
910: rate is NULL in MSI. */
911: UPDATE CST_ITEM_COSTS A
912: SET SHRINKAGE_RATE = (
913: SELECT NVL(SHRINKAGE_RATE,0)
914: FROM MTL_SYSTEM_ITEMS
915: WHERE ORGANIZATION_ID = I_ORG_ID