eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.INVFV_CUSTOMER_ITEMS

Object Details

Object Name:	INVFV_CUSTOMER_ITEMS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVFV_CUSTOMER_ITEMS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows items or products that the customer either produces or purchases. These items are usually stocked in the customer's inventory. These include all global items plus items maintained by individual business units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Name of customer
CUSTOMER_ITEM_NAME	VARCHAR2	(50)	Yes	Customer's part number
COUNTRY	VARCHAR2	(60)		Country of customer's address
ADDRESS1	VARCHAR2	(240)		First line of customer's address
ADDRESS2	VARCHAR2	(240)		Second line of customer's address
ADDRESS3	VARCHAR2	(240)		Third line of customer's address
ADDRESS4	VARCHAR2	(240)		Fourth line of customer's address
CITY	VARCHAR2	(60)		City of customer's address
POSTAL_CODE	VARCHAR2	(60)		Postal code of customer's address
STATE	VARCHAR2	(60)		State of customer's address
PROVINCE	VARCHAR2	(60)		Province of customer's address
COUNTY	VARCHAR2	(60)		County of customer's address
ADDRESS_CATEGORY	VARCHAR2	(80)		Address category
_LA:DEFINITION_LEVEL	CHAR	(77)		Level at which this item definition applies
CUSTOMER_ITEM_DESCRIPTION	VARCHAR2	(240)		Description of customer item
MINIMUM_FILL_PERCENT	NUMBER			Minimum fill percentage at which this container type should be
POSITIVE_TOLERANCE_PERCENT	NUMBER			Positive tolerance (high end) for Customer Item demand
NEGATIVE_TOLERANCE_PERCENT	NUMBER			Negative tolerance (low end) for Customer Item demand
MODEL_CUSTOMER_ITEM_NAME	VARCHAR2	(50)		Name of the default parent model customer item
COMMODITY_CODE	VARCHAR2	(30)		Customer item commodity code
CONTAINER_ORGANIZATION_NAME	VARCHAR2	(240)		Item master organization name for the master and detail container items
CONTAINER_ORGANIZATION_CODE	VARCHAR2	(3)		Item master organization code for the master and detail container items
_KF:MASTER_CONTAINER_ITEM	CHAR	(16)		Master container item name
_KF:DETAIL_CONTAINER_ITEM	CHAR	(16)		Detail container item name
_LA:DEPARTURE_PLAN_RQD_FLAG	CHAR	(59)		Indicates if a departure plan must be created
_LA:PLAN_BEFORE_BUILD_FLAG	CHAR	(60)		Departure plan must be built before creation of work order
_LA:ACTIVE_FLAG	CHAR	(58)		Indicates if item is orderable
CUSTOMER_CATEGORY_CODE	VARCHAR2	(30)		Address category code
CUSTOMER_ITEM_ID	NUMBER		Yes	Customer item identifier
CUSTOMER_ID	NUMBER		Yes	Customer identifier
ADDRESS_ID	NUMBER			Address identifier
MODEL_CUSTOMER_ITEM_ID	NUMBER			Default parent model customer item identifier
COMMODITY_CODE_ID	NUMBER
CONTAINER_ITEM_ORG_ID	NUMBER			Item master organization identifier for the master and detail container items
MASTER_CONTAINER_ITEM_ID	NUMBER			Master container item identifier
DETAIL_CONTAINER_ITEM_ID	NUMBER			Detail container item identifier
LAST_UPDATED_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATED_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column

Query Text

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


SELECT CUSTOMER_NAME
,      CUSTOMER_ITEM_NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      ADDRESS_CATEGORY
,      _LA:DEFINITION_LEVEL
,      CUSTOMER_ITEM_DESCRIPTION
,      MINIMUM_FILL_PERCENT
,      POSITIVE_TOLERANCE_PERCENT
,      NEGATIVE_TOLERANCE_PERCENT
,      MODEL_CUSTOMER_ITEM_NAME
,      COMMODITY_CODE
,      CONTAINER_ORGANIZATION_NAME
,      CONTAINER_ORGANIZATION_CODE
,      _KF:MASTER_CONTAINER_ITEM
,      _KF:DETAIL_CONTAINER_ITEM
,      _LA:DEPARTURE_PLAN_RQD_FLAG
,      _LA:PLAN_BEFORE_BUILD_FLAG
,      _LA:ACTIVE_FLAG
,      CUSTOMER_CATEGORY_CODE
,      CUSTOMER_ITEM_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      MODEL_CUSTOMER_ITEM_ID
,      COMMODITY_CODE_ID
,      CONTAINER_ITEM_ORG_ID
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_CUSTOMER_ITEMS;

Dependencies

[top of page]

APPS.INVFV_CUSTOMER_ITEMS references the following:

APPS: AR_LOOKUPS; HR_ALL_ORGANIZATION_UNITS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_LOC_ASSIGNMENTS; HZ_PARTIES; HZ_PARTY_SITES; MTL_COMMODITY_CODES; MTL_CUSTOMER_ITEMS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS

APPS.INVFV_CUSTOMER_ITEMS is not referenced by any database object