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

VIEW: APPS.JTM_CSP_REQUIREMENTS_V

Object Details
Object Name: JTM_CSP_REQUIREMENTS_V
Object Type: VIEW
Owner: APPS
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 Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER

REQUIREMENT_LINE_ID NUMBER (35) Yes
REQUIREMENT_HEADER_ID NUMBER (35) Yes
INVENTORY_ITEM_ID NUMBER (35) Yes
UOM_CODE VARCHAR2 (3) Yes
REQUIRED_QUANTITY NUMBER
Yes
SHIP_COMPLETE_FLAG VARCHAR2 (3)
LIKELIHOOD NUMBER (35)
REVISION VARCHAR2 (3)
SOURCE_ORGANIZATION_ID NUMBER (35)
SOURCE_SUBINVENTORY VARCHAR2 (10)
ORDERED_QUANTITY NUMBER (35)
ORDER_LINE_ID NUMBER (35)
RESERVATION_ID NUMBER (35)
LOCAL_RESERVATION_ID VARCHAR2 (240)
ORDER_BY_DATE DATE

ARRIVAL_DATE DATE

ITEM_SCRATCHPAD VARCHAR2 (1996)
Query Text

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


SELECT ACCESS_ID
,      REQUIREMENT_LINE_ID
,      REQUIREMENT_HEADER_ID
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      REQUIRED_QUANTITY
,      SHIP_COMPLETE_FLAG
,      LIKELIHOOD
,      REVISION
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      ORDERED_QUANTITY
,      ORDER_LINE_ID
,      RESERVATION_ID
,      LOCAL_RESERVATION_ID
,      ORDER_BY_DATE
,      ARRIVAL_DATE
,      ITEM_SCRATCHPAD
FROM APPS.JTM_CSP_REQUIREMENTS_V;

Dependencies

[top of page]

APPS.JTM_CSP_REQUIREMENTS_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSP_REQUIREMENT_LINES
SynonymJTM_CSP_REQ_LINES_ACC

APPS.JTM_CSP_REQUIREMENTS_V is not referenced by any database object