DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on MTL_SYSTEM_ITEMS

Line 978: FROM MTL_SYSTEM_ITEMS

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
980: AND INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
981: )
982: WHERE ORGANIZATION_ID = I_ORG_ID

Line 1011: FROM MTL_SYSTEM_ITEMS

1007: I_REQUEST_ID,
1008: I_PROGRAM_APPL_ID,
1009: I_PROGRAM_ID,
1010: SYSDATE
1011: FROM MTL_SYSTEM_ITEMS
1012: WHERE ORGANIZATION_ID = I_ORG_ID
1013: AND INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
1014: )
1015: WHERE ORGANIZATION_ID = I_ORG_ID