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

VIEW: APPS.BOM_STRUCTURE_SYNC_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This View is used for Structure Sync operations with external systems. Currently this is being used for Complex Product Sync with Siebel

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_ID NUMBER

Assembly Item identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
SORT_ORDER VARCHAR2 (2000) Yes Sort Order for Explosion
PARENT_SORT_ORDER VARCHAR2 (2000)
Parent Sort Order for Explosion
PLAN_LEVEL NUMBER
Yes Plan Level for Explosion
EXPLODE_GROUP_ID NUMBER

Explosion Group Identifier
TOP_ITEM_ID NUMBER
Yes Top Item Identifier
TOP_BILL_SEQUENCE_ID NUMBER
Yes Top Bill Sequence Identifier
BILL_SEQUENCE_ID NUMBER
Yes Bill Sequence Identifier
COMPONENT_ITEM_ID NUMBER
Yes Component Item Identifier
COMPONENT_SEQUENCE_ID NUMBER

Component Sequence Id
COMPONENT_QUANTITY NUMBER

Component Quantity
EFFECTIVITY_DATE DATE

Start Effective Date for Component
DISABLE_DATE DATE

Disable Date for Component
COMP_BILL_SEQ_ID NUMBER

Component Bill Sequence Identifier
ASSEMBLY_ITEM_NAME VARCHAR2 (40)
Assembly Item Name
ASSEMBLY_ITEM_DESCRIPTION VARCHAR2 (240)
Assembly Item Description
ASSEM_CUSTORDERENABLED_FLAG VARCHAR2 (1) Yes Customer Order Enabled Flag for Assembly
ASSEM_CUSTORDER_FLAG VARCHAR2 (1) Yes Customer Orderable Flag for Assembly
ASSEM_EFFECTIVITY_CONTROL NUMBER

Effectivity Control for Assembly
ASSEMBLY_BOM_ITEM_TYPE NUMBER
Yes BOM Item Type for Assembly
ASSEM_PRIMARY_UOM VARCHAR2 (3)
Primary UOM Code for Assembly
COMPONENT_ITEM_NAME VARCHAR2 (40)
Component Item Name
COMPONENT_ITEM_DESCRIPTION VARCHAR2 (240)
Component Item Description
COMP_CUSTORDERENABLED_FLAG VARCHAR2 (1) Yes Customer Order Enabled Flag for Component
COMP_CUSORDER_FLAG VARCHAR2 (1) Yes Customer Orderable Flag for Component
COMP_EFFECTIVITY_CONTROL NUMBER

Effectivity Control for Component
COMP_BOM_ITEM_TYPE NUMBER
Yes BOM Item Type for Component
COMP_PRIMARY_UOM VARCHAR2 (3)
Primary UOM Code for Component
OPERATING_UNIT_NAME VARCHAR2 (240) Yes Operating Unit Name
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ORGANIZATION_NAME VARCHAR2 (3)
Organization Name
OPERATING_UNIT_ID NUMBER (15) Yes Operating Unit Id
Query Text

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


SELECT ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      SORT_ORDER
,      PARENT_SORT_ORDER
,      PLAN_LEVEL
,      EXPLODE_GROUP_ID
,      TOP_ITEM_ID
,      TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_QUANTITY
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      COMP_BILL_SEQ_ID
,      ASSEMBLY_ITEM_NAME
,      ASSEMBLY_ITEM_DESCRIPTION
,      ASSEM_CUSTORDERENABLED_FLAG
,      ASSEM_CUSTORDER_FLAG
,      ASSEM_EFFECTIVITY_CONTROL
,      ASSEMBLY_BOM_ITEM_TYPE
,      ASSEM_PRIMARY_UOM
,      COMPONENT_ITEM_NAME
,      COMPONENT_ITEM_DESCRIPTION
,      COMP_CUSTORDERENABLED_FLAG
,      COMP_CUSORDER_FLAG
,      COMP_EFFECTIVITY_CONTROL
,      COMP_BOM_ITEM_TYPE
,      COMP_PRIMARY_UOM
,      OPERATING_UNIT_NAME
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      OPERATING_UNIT_ID
FROM APPS.BOM_STRUCTURE_SYNC_V;

Dependencies

[top of page]

APPS.BOM_STRUCTURE_SYNC_V references the following:

SchemaAPPS
SynonymBOM_EXPLOSIONS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ORGANIZATION_INFORMATION
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
APPS.BOM_STRUCTURE_SYNC_V is referenced by following:

SchemaAPPS
Package BodyBOM_STRUCT_SYNC_PUB - show dependent code