DBA Data[Home] [Help]

APPS.CSICUMPI_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 69: MTL_SYSTEM_ITEMS_KFV MSIK

65: CII.LOT_NUMBER LOT,
66: MSIK.CONCATENATED_SEGMENTS PRODUCT,
67: MSIK.DESCRIPTION DESCRIPTION
68: FROM CSI_ITEM_INSTANCES CII,
69: MTL_SYSTEM_ITEMS_KFV MSIK
70: WHERE MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
71: AND CII.INSTANCE_ID = P_INSTANCE_ID
72: AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID;
73:

Line 112: MTL_SYSTEM_ITEMS_KFV MSIK

108: CII.Instance_Number,
109: CII.Serial_Number,
110: CII.Lot_Number
111: FROM CSI_Item_Instances CII,
112: MTL_SYSTEM_ITEMS_KFV MSIK
113: WHERE CII.Instance_Id = P_Customer_Product_Id
114: AND CII.Inventory_Item_Id = MSIK.Inventory_Item_ID
115: AND CII.Inv_Master_Organization_Id = MSIK.Organization_Id;
116: