VIEW: APPS.CSD_BOM_INQUIRY_EXPL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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