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


VIEW: APPS.MTL_SYSTEM_ITEMS_FKEYS_V

Object Details
Object Name: MTL_SYSTEM_ITEMS_FKEYS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_SYSTEM_ITEMS_FKEYS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
ORGANIZATION_CODE VARCHAR2 (3)

MASTER_ORGANIZATION_ID NUMBER


CHILD_ORG_FLAG NUMBER


BUYER VARCHAR2 (240)

ACCOUNTING_RULE VARCHAR2 (30)

INVOICING_RULE VARCHAR2 (30)

DEFAULT_SHIPPING_ORG_DSP VARCHAR2 (240)

QTY_RCV_EXCEPTION VARCHAR2 (80)

HAZARD_CLASS VARCHAR2 (40)

UN_NUMBER VARCHAR2 (25)

ENFORCE_SHIP_TO_LOCATION VARCHAR2 (80)

RECEIPT_DAYS_EXCEPTION VARCHAR2 (80)

RECEIVING_ROUTING VARCHAR2 (80)

SOURCE_ORGANIZATION VARCHAR2 (240)

ATP_RULE VARCHAR2 (80)

PICKING_RULE VARCHAR2 (30)

PAYMENT_TERMS VARCHAR2 (15)

ITEM_TYPE_DSP VARCHAR2 (80)

CONTAINER_TYPE_DSP VARCHAR2 (80)

INVENTORY_PLANNING VARCHAR2 (80)

LOCATION_CONTROL VARCHAR2 (80)

LOT_CONTROL VARCHAR2 (80)

MRP_PLANNING VARCHAR2 (80)

MRP_SAFETY_STOCK VARCHAR2 (80)

OUTSIDE_OPERATION_UOM VARCHAR2 (80)

PLANNING_MAKE_BUY VARCHAR2 (80)

PLANNING_TIME_FENCE VARCHAR2 (80)

RESERVABLE VARCHAR2 (80)

RESTRICT_LOCATORS VARCHAR2 (80)

RESTRICT_SUBINVENTORIES VARCHAR2 (80)

RETURN_INSPECTION_REQUIRE_DSP VARCHAR2 (80)

REVISION_QTY_CONTROL VARCHAR2 (80)

ROUNDING_CONTROL VARCHAR2 (80)

SERIAL_NUMBER_CONTROL VARCHAR2 (80)

SHELF_LIFE VARCHAR2 (80)

SOURCE_TYPE_DSP VARCHAR2 (80)

WIP_SUPPLY VARCHAR2 (80)

ALLOWED_UNITS_LOOKUP VARCHAR2 (80)

ATO_FORECAST_CONTROL_DSP VARCHAR2 (80)

AUTO_REDUCE_MPS_DSP VARCHAR2 (80)

BOM_ITEM_TYPE_DSP VARCHAR2 (80)

DEMAND_TIME_FENCE VARCHAR2 (80)

RELEASE_TIME_FENCE VARCHAR2 (80)

ENGINEERING_DATE DATE


COVERAGE VARCHAR2 (240)

BILLABLE_FLAG VARCHAR2 (80)

PEGGING VARCHAR2 (80)

ATP_FLAG VARCHAR2 (80)
ATP_COMPONENTS_FLAG VARCHAR2 (80)
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      MASTER_ORGANIZATION_ID
,      CHILD_ORG_FLAG
,      BUYER
,      ACCOUNTING_RULE
,      INVOICING_RULE
,      DEFAULT_SHIPPING_ORG_DSP
,      QTY_RCV_EXCEPTION
,      HAZARD_CLASS
,      UN_NUMBER
,      ENFORCE_SHIP_TO_LOCATION
,      RECEIPT_DAYS_EXCEPTION
,      RECEIVING_ROUTING
,      SOURCE_ORGANIZATION
,      ATP_RULE
,      PICKING_RULE
,      PAYMENT_TERMS
,      ITEM_TYPE_DSP
,      CONTAINER_TYPE_DSP
,      INVENTORY_PLANNING
,      LOCATION_CONTROL
,      LOT_CONTROL
,      MRP_PLANNING
,      MRP_SAFETY_STOCK
,      OUTSIDE_OPERATION_UOM
,      PLANNING_MAKE_BUY
,      PLANNING_TIME_FENCE
,      RESERVABLE
,      RESTRICT_LOCATORS
,      RESTRICT_SUBINVENTORIES
,      RETURN_INSPECTION_REQUIRE_DSP
,      REVISION_QTY_CONTROL
,      ROUNDING_CONTROL
,      SERIAL_NUMBER_CONTROL
,      SHELF_LIFE
,      SOURCE_TYPE_DSP
,      WIP_SUPPLY
,      ALLOWED_UNITS_LOOKUP
,      ATO_FORECAST_CONTROL_DSP
,      AUTO_REDUCE_MPS_DSP
,      BOM_ITEM_TYPE_DSP
,      DEMAND_TIME_FENCE
,      RELEASE_TIME_FENCE
,      ENGINEERING_DATE
,      COVERAGE
,      BILLABLE_FLAG
,      PEGGING
,      ATP_FLAG
,      ATP_COMPONENTS_FLAG
FROM APPS.MTL_SYSTEM_ITEMS_FKEYS_V;

Dependencies

[top of page]

APPS.MTL_SYSTEM_ITEMS_FKEYS_V references the following:

SchemaAPPS
ViewCS_LOOKUPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_ATP_RULES
SynonymMTL_PARAMETERS
SynonymMTL_PICKING_RULES
SynonymMTL_SYSTEM_ITEMS_B
ViewOKS_COVERAGE_TEMPLTS_V
ViewPER_PEOPLE_F
SynonymPO_HAZARD_CLASSES
ViewPO_LOOKUP_CODES
SynonymPO_UN_NUMBERS
SynonymRA_RULES
SynonymRA_TERMS
ViewRCV_ROUTING_HEADERS
APPS.MTL_SYSTEM_ITEMS_FKEYS_V is referenced by following:

SchemaAPPS
ViewMTL_ITEM_ATTRIBUTE_VALUES_V