View: CSD_BOM_INQUIRY_EXPL_V

Product:	CSD - Depot Repair
Description:	View based on temporary table.
Implementation/DBA Data:	APPS.CSD_BOM_INQUIRY_EXPL_V

View Text

SELECT CBET.ROWID
, CBET.BILL_SEQUENCE_ID
, CBET.ORGANIZATION_ID
, CBET.COMPONENT_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM
, MSI.DESCRIPTION
, CBET.COMPONENT_SEQUENCE_ID
, CBET.PLAN_LEVEL
, CBET.SORT_ORDER
, CBET.TOP_ALTERNATE_DESIGNATOR
, CBET.TOP_ITEM_ID
, CBET.SELECT_QUANTITY
, CBET.COMPONENT_QUANTITY
, CBET.HEADER_ID
, CBET.LINE_ID
, CBET.LIST_PRICE
, CBET.SELLING_PRICE
, CBET.ITEM_COST
, MSI.PRIMARY_UOM_CODE
, MSI.PRIMARY_UNIT_OF_MEASURE
, CBET.ASSEMBLY_ITEM_ID
, CBET.PRICE_LIST_ID
, CBET.WIP_SUPPLY_TYPE
, CBET.ITEM_NUM
, CBET.EFFECTIVITY_DATE
, CBET.DISABLE_DATE
, CBET.OPERATION_OFFSET
, CBET.TOP_BILL_SEQUENCE_ID
FROM CSD_BOM_EXPL_TEMP CBET
, MTL_SYSTEM_ITEMS_KFV MSI
, BOM_BILL_OF_MATERIALS BOM
WHERE CBET.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CBET.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID AND MSI.MATERIAL_BILLABLE_FLAG = 'M' AND CBET.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID

Columns