[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:	INV.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

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

CS_LOOKUPS

FND_COMMON_LOOKUPS

FND_GLOBAL - show dependent code

FND_LOOKUPS

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

MFG_LOOKUPS

MTL_ATP_RULES

MTL_PARAMETERS

MTL_PICKING_RULES

MTL_SYSTEM_ITEMS_B

OKS_COVERAGE_TEMPLTS_V

PER_PEOPLE_F

PO_HAZARD_CLASSES

PO_LOOKUP_CODES

PO_UN_NUMBERS

RA_RULES

RA_TERMS

RCV_ROUTING_HEADERS

APPS

MTL_ITEM_ATTRIBUTE_VALUES_V