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


VIEW: APPS.CSP_DC_PARTS_V

Object Details
Object Name: CSP_DC_PARTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_DC_PARTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUIREMENT_NUMBER NUMBER (35)
REQUIREMENT_LINE_ID NUMBER (35)
REQ_LINE_DETAIL_ID NUMBER

SOURCED_FROM VARCHAR2 (80)
ORDER_NUMBER NUMBER

INVENTORY_ITEM_ID NUMBER (35)
ITEM_NUMBER VARCHAR2 (40)
CATEGORY VARCHAR2 (80)
STATUS VARCHAR2 (4000)
STATUS_MEANING VARCHAR2 (4000)
ITEM_SUPPLIED VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)
SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
SOURCE_ORGANIZATION_NAME VARCHAR2 (240)
REQUIRED_QUANTITY NUMBER

ORDERED_QUANTITY NUMBER

ORDERED_QUANTITY_UOM VARCHAR2 (3)
NEED_BY_DATE DATE

ORDER_BY_DATE DATE

SCHEDULE_ARRIVAL_DATE DATE

TASK_ID NUMBER (35)
TASK_ASSIGNMENT_ID NUMBER (35)
SHIPPING_METHOD VARCHAR2 (80)
DISTANCE VARCHAR2 (4000)
SHIP_COST NUMBER

Query Text

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


SELECT REQUIREMENT_NUMBER
,      REQUIREMENT_LINE_ID
,      REQ_LINE_DETAIL_ID
,      SOURCED_FROM
,      ORDER_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      CATEGORY
,      STATUS
,      STATUS_MEANING
,      ITEM_SUPPLIED
,      DESCRIPTION
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      REQUIRED_QUANTITY
,      ORDERED_QUANTITY
,      ORDERED_QUANTITY_UOM
,      NEED_BY_DATE
,      ORDER_BY_DATE
,      SCHEDULE_ARRIVAL_DATE
,      TASK_ID
,      TASK_ASSIGNMENT_ID
,      SHIPPING_METHOD
,      DISTANCE
,      SHIP_COST
FROM APPS.CSP_DC_PARTS_V;

Dependencies

[top of page]

APPS.CSP_DC_PARTS_V references the following:

SchemaAPPS
ViewCSP_PART_PRIORITIES_V
PL/SQL PackageCSP_PART_SEARCH_PVT - show dependent code
PL/SQL PackageCSP_PICK_UTILS - show dependent code
SynonymCSP_REQUIREMENT_HEADERS
SynonymCSP_REQUIREMENT_LINES
SynonymCSP_REQ_LINE_DETAILS
ViewCSP_SHIPPING_DETAILS_V
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewFND_LOOKUP_VALUES_VL
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_RESERVATIONS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymPO_HEADERS
PL/SQL PackagePO_HEADERS_SV3 - show dependent code
ViewPO_LINE_LOCATIONS_V
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES

APPS.CSP_DC_PARTS_V is not referenced by any database object