DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on MTL_SYSTEM_ITEMS_TL

Line 940: From MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T --OKX_SYSTEM_ITEMS_V

936: Select B.INVENTORY_ITEM_ID Id1,
937: T.DESCRIPTION Name,
938: B.CONCATENATED_SEGMENTS Description,
939: B.COVERAGE_SCHEDULE_ID COVERAGE_TEMPLATE_ID
940: From MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T --OKX_SYSTEM_ITEMS_V
941: Where B.SERVICE_ITEM_FLAG='Y'
942: And B.VENDOR_WARRANTY_FLAG = 'N'
943: And B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
944: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID