DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on MTL_SYSTEM_ITEMS

Line 914: FROM MTL_SYSTEM_ITEMS

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
916: AND INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
917: )
918: WHERE ORGANIZATION_ID = I_ORG_ID

Line 947: FROM MTL_SYSTEM_ITEMS

943: I_REQUEST_ID,
944: I_PROGRAM_APPL_ID,
945: I_PROGRAM_ID,
946: SYSDATE
947: FROM MTL_SYSTEM_ITEMS
948: WHERE ORGANIZATION_ID = I_ORG_ID
949: AND INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
950: )
951: WHERE ORGANIZATION_ID = I_ORG_ID