[Home] [Help] [Dependency Information]
Object Name: | INVBV_CUSTOMER_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.INVBV_CUSTOMER_ITEMS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | |
CUSTOMER_ITEM_NAME | VARCHAR2 | (50) | Yes | |
COUNTRY | VARCHAR2 | (60) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
ADDRESS_CATEGORY | VARCHAR2 | (80) | ||
_LA:DEFINITION_LEVEL | CHAR | (76) | ||
CUSTOMER_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
MINIMUM_FILL_PERCENT | NUMBER | |||
POSITIVE_TOLERANCE_PERCENT | NUMBER | |||
NEGATIVE_TOLERANCE_PERCENT | NUMBER | |||
_LA:DEPARTURE_PLAN_RQD_FLAG | CHAR | (58) | ||
_LA:PLAN_BEFORE_BUILD_FLAG | CHAR | (59) | ||
_LA:ACTIVE_FLAG | CHAR | (57) | ||
CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
CUSTOMER_ITEM_ID | NUMBER | Yes | ||
CUSTOMER_ID | NUMBER | Yes | ||
ADDRESS_ID | NUMBER | |||
MODEL_CUSTOMER_ITEM_ID | NUMBER | |||
COMMODITY_CODE_ID | NUMBER | |||
MASTER_CONTAINER_ITEM_ID | NUMBER | |||
CONTAINER_ITEM_ORGANIZATION_ID | NUMBER | |||
DETAIL_CONTAINER_ITEM_ID | NUMBER | |||
CREATED_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATED_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes |
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
, _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
, MASTER_CONTAINER_ITEM_ID
, CONTAINER_ITEM_ORGANIZATION_ID
, DETAIL_CONTAINER_ITEM_ID
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
FROM APPS.INVBV_CUSTOMER_ITEMS;
APPS.INVBV_CUSTOMER_ITEMS is not referenced by any database object
|
|
|