DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_EXPL_INQUIRY_VIEW

Object Details
Object Name: BOM_EXPL_INQUIRY_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_EXPL_INQUIRY_VIEW
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID VARCHAR2 (18)
Rowid of table BOM_SMALL_EXPL_TEMP
TOP_BILL_SEQUENCE_ID NUMBER
Yes Bill identifier of top level bill
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
COMPONENT_ITEM_ID NUMBER

Component item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number
PLAN_LEVEL NUMBER
Yes Level in indented structure
EXTENDED_QUANTITY NUMBER
Yes Extended quantity
ITEM_NUM NUMBER

Sequence number in routing
SORT_ORDER VARCHAR2 (2000)
Sort order for retrieving tree information
GROUP_ID NUMBER

Group identifier
ITEM_COST NUMBER

Item cost
RESERVABLE_TYPE NUMBER

Flag to show if item is reservable
EXTEND_COST_FLAG NUMBER

Flag to show if costs should be extended
TOP_ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate of top level bill
TOP_ITEM_ID NUMBER

Item identifier of top level bill
IMPLEMENTATION_DATE DATE

Implementation date
IMPLEMENTED_FLAG NUMBER

Implemented (yes or no)
OPTIONAL NUMBER

Flag to show if component is optional
PLANNING_FACTOR NUMBER

Planning factor
COMPONENT_YIELD_FACTOR NUMBER

Component yield factor
INCLUDE_IN_COST_ROLLUP NUMBER

Flag to show if item should be included in cost rollup
WIP_SUPPLY_TYPE NUMBER

Supply type
SUPPLY_TYPE VARCHAR2 (80)
Descriptor for WIP supply type
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
LOCATOR VARCHAR2 (40)
Concatenated segments of supply locator
COMPONENT_REMARKS VARCHAR2 (240)
Component remarks
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
BASIS_TYPE VARCHAR2 (80)
COMPONENT_QUANTITY NUMBER

Quantity
OPERATION_LEAD_TIME_PERCENT NUMBER

Lead time percent
OPERATION_OFFSET NUMBER

Lead time offset of the operation
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag to show if options below are mutually exclusive
CHECK_ATP NUMBER

Flag to indicate if ATP check should be performed
REQUIRED_TO_SHIP NUMBER

Flag to show if item is required to ship
SO_BASIS VARCHAR2 (80)
Order basis
REQUIRED_FOR_REVENUE NUMBER

Flag to show if item is required for revenue
INCLUDE_ON_SHIP_DOCS NUMBER

Flag to indicate if item is to be shown on shipping documents
MINIMUM_QUANTITY NUMBER

minimum order quantity
MAXIMUM_QUANTITY NUMBER

maximum order quantity
UNIT_OF_MEASURE VARCHAR2 (3)
Unit of measure
ITEM_TYPE VARCHAR2 (30)
User defined item type
ITEM_TYPE_DESCRIPTION VARCHAR2 (80)
Description of user defined item type
ITEM_STATUS VARCHAR2 (10) Yes Item Status
DESCRIPTION VARCHAR2 (4000)
Description
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag showing if item is an engineering item
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
MANUFACTURING_LEAD_TIME NUMBER

Manufacturing lead time
PARENT_ITEM_ID NUMBER

Parent item identifier
PARENT_ALTERNATE VARCHAR2 (10)
Alternate of parent bill
PARENT_ALTERNATE_FLAG NUMBER

Is the parent bill an alternate?
ENG_BILL NUMBER

Flag showing if bill is an engineering bill
DISPLAY_PLAN_LEVEL VARCHAR2 (4000)
Formatted plan level
EFFECTIVITY_TIME VARCHAR2 (5)
Effective time
DISABLE_TIME VARCHAR2 (5)
Disable time
EXTENDED_QUANTITY6 NUMBER
Yes Extended quantity
EXTENDED_COST NUMBER

Extended cost
OPERATION_SEQ_NUM7 NUMBER

Operation sequence number
BOM_ITEM_TYPE NUMBER
Yes BOM item type of item
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Flag showing if work ordered is opened for this item
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag showing if components of this item are to be picked
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag showing if components of item should be checked for ATP
ATP_FLAG VARCHAR2 (1) Yes Flag showing if ATP check is performed for item (item level)
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag showing if item is shippable
MRP_PLANNING_CODE NUMBER

MPR planning option
SO_TRANSACTIONS_FLAG VARCHAR2 (1) Yes Sales order transactions flag
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is customer orderable
INVOICE_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is invoiceable
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Flag indicating item is an inventory asset
ITEM_NUMBER VARCHAR2 (4000)
Item name consisting of concatenated item flexfield segments
PADDED_ITEM_NUMBER VARCHAR2 (40)
Item name blank padded to 40 characters
CURRENT_REVISION VARCHAR2 (3)
Current item revision of component
EFFECTIVE_FROM VARCHAR2 (30)
EFFECTIVE_TO VARCHAR2 (30)
EFFECTIVITY_CONTROL VARCHAR2 (80)
DISABLED_FLAG NUMBER

Disabled (Yes/No)
FROM_EFFECTIVITY_DATE DATE

TO_EFFECTIVITY_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      ITEM_NUM
,      SORT_ORDER
,      GROUP_ID
,      ITEM_COST
,      RESERVABLE_TYPE
,      EXTEND_COST_FLAG
,      TOP_ALTERNATE_DESIGNATOR
,      TOP_ITEM_ID
,      IMPLEMENTATION_DATE
,      IMPLEMENTED_FLAG
,      OPTIONAL
,      PLANNING_FACTOR
,      COMPONENT_YIELD_FACTOR
,      INCLUDE_IN_COST_ROLLUP
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      LOCATOR
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      OPERATION_LEAD_TIME_PERCENT
,      OPERATION_OFFSET
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      CHECK_ATP
,      REQUIRED_TO_SHIP
,      SO_BASIS
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      MINIMUM_QUANTITY
,      MAXIMUM_QUANTITY
,      UNIT_OF_MEASURE
,      ITEM_TYPE
,      ITEM_TYPE_DESCRIPTION
,      ITEM_STATUS
,      DESCRIPTION
,      ENG_ITEM_FLAG
,      CUM_MANUFACTURING_LEAD_TIME
,      CUMULATIVE_TOTAL_LEAD_TIME
,      MANUFACTURING_LEAD_TIME
,      PARENT_ITEM_ID
,      PARENT_ALTERNATE
,      PARENT_ALTERNATE_FLAG
,      ENG_BILL
,      DISPLAY_PLAN_LEVEL
,      EFFECTIVITY_TIME
,      DISABLE_TIME
,      EXTENDED_QUANTITY6
,      EXTENDED_COST
,      OPERATION_SEQ_NUM7
,      BOM_ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      PICK_COMPONENTS_FLAG
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      SHIPPABLE_ITEM_FLAG
,      MRP_PLANNING_CODE
,      SO_TRANSACTIONS_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INVOICE_ENABLED_FLAG
,      INVENTORY_ASSET_FLAG
,      ITEM_NUMBER
,      PADDED_ITEM_NUMBER
,      CURRENT_REVISION
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      EFFECTIVITY_CONTROL
,      DISABLED_FLAG
,      FROM_EFFECTIVITY_DATE
,      TO_EFFECTIVITY_DATE
FROM APPS.BOM_EXPL_INQUIRY_VIEW;

Dependencies

[top of page]

APPS.BOM_EXPL_INQUIRY_VIEW references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
PL/SQL PackageBOM_GLOBALS - show dependent code
SynonymBOM_SMALL_EXPL_TEMP
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageINV_MEANING_SEL - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.BOM_EXPL_INQUIRY_VIEW is not referenced by any database object