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


VIEW: APPS.CSP_REQUIRED_PARTS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


View which gives you the complete status of spare part requirements


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUIREMENT_NUMBER NUMBER (35)
Requirement Number
REQUIREMENT_LINE_ID NUMBER (35)
Requirement Line Identifier
REQ_LINE_DETAIL_ID NUMBER

Requirement line detail identifier
SOURCED_FROM VARCHAR2 (80)
The requirement will be sourced from this source type
PO_REQUISITION_LINE_ID NUMBER

Purchase order requisition line id
PO_REQUISITION_HEADER_ID NUMBER

Purchase requisition header id
PO_REQUISITION_NUMBER VARCHAR2 (20)
Purchase requisition number
PO_LINE_LOCATION_ID NUMBER

Purchase order line location id
ORDER_HEADER_ID NUMBER

Order Header Identifier
ORDER_LINE_ID NUMBER

Order Line Identifier
ORDER_NUMBER NUMBER

Order Number
INVENTORY_ITEM_ID NUMBER (35)
Inventory Item Identifier
ITEM_NUMBER VARCHAR2 (40)
Item Number
CATEGORY VARCHAR2 (80)
Category
STATUS VARCHAR2 (4000)
Status
STATUS_MEANING VARCHAR2 (4000)
Status Meaning
ITEM_SUPPLIED VARCHAR2 (40)
Item supplied
DESCRIPTION VARCHAR2 (240)
Description
SOURCE_ORGANIZATION_ID NUMBER

Source Organization Identifier
SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
Source Organization Code
DESTINATION_ORGANIZATION_ID NUMBER (35)
Destination Organization Identifier
DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)
Destination Organization Code
SHIP_TO_LOCATION_ID NUMBER (35)
Ship To Location Identifier
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight Carrier Code
FREIGHT_CARRIER VARCHAR2 (80)
Freight Carrier
REQUIRED_QUANTITY NUMBER

Required Quantity
ORDERED_QUANTITY NUMBER

Ordered Quantity
ORDER_QUANTITY_UOM VARCHAR2 (3)
Order Quantity Unit Of Measure
FULFILLED_QUANTITY NUMBER

Fulfilled Quantity
SHIPPING_QUANTITY NUMBER

Shipping Quantity
SHIPPING_QUANTITY_UOM VARCHAR2 (3)
Shipping Quantity Unit Of Measure
SHIPPED_QUANTITY NUMBER

Shipped Quantity
RECEIVED_QUANTITY NUMBER

Received Quantity
RECEIVED_QUANTITY_UOM VARCHAR2 (4000)
Received Quantity Unit Of Measurre
CANCELLED_QUANTITY NUMBER

Cancelled Quantity
DELIVERY_NUMBER VARCHAR2 (4000)
Delivery number
WAYBILL_NUM VARCHAR2 (4000)
Waybill Number
NEED_BY_DATE DATE

Need By Date
ORDER_BY_DATE DATE

Order By Date
REQUEST_DATE DATE

Request Date
PROMISE_DATE DATE

Promise Date
SCHEDULE_SHIP_DATE DATE

Schedule Ship Date
ACTUAL_SHIPMENT_DATE DATE

Actual Shipment Date
SCHEDULE_ARRIVAL_DATE DATE

Schedule Arrival Date
ACTUAL_ARRIVAL_DATE DATE

Actual Arrival Date
SERVICE_REQUEST VARCHAR2 (80)
Service Request
INCIDENT_ID NUMBER

Incident Identifier
TASK_ID NUMBER (35)
Task Identifier
TASK_NUMBER VARCHAR2 (30)
Task Number
TASK_ASSIGNMENT_ID NUMBER (35)
Task Assignment Identifier
RESOURCE_TYPE VARCHAR2 (240)
Resource Type
RESOURCE_TYPE_MEANING VARCHAR2 (30)
Resource Type Meaning
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_NAME VARCHAR2 (4000)
Resource Name
ADDRESS_TYPE VARCHAR2 (30)
Address type
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
,      PO_REQUISITION_LINE_ID
,      PO_REQUISITION_HEADER_ID
,      PO_REQUISITION_NUMBER
,      PO_LINE_LOCATION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      ORDER_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      CATEGORY
,      STATUS
,      STATUS_MEANING
,      ITEM_SUPPLIED
,      DESCRIPTION
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      SHIP_TO_LOCATION_ID
,      FREIGHT_CARRIER_CODE
,      FREIGHT_CARRIER
,      REQUIRED_QUANTITY
,      ORDERED_QUANTITY
,      ORDER_QUANTITY_UOM
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      SHIPPED_QUANTITY
,      RECEIVED_QUANTITY
,      RECEIVED_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      DELIVERY_NUMBER
,      WAYBILL_NUM
,      NEED_BY_DATE
,      ORDER_BY_DATE
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_SHIP_DATE
,      ACTUAL_SHIPMENT_DATE
,      SCHEDULE_ARRIVAL_DATE
,      ACTUAL_ARRIVAL_DATE
,      SERVICE_REQUEST
,      INCIDENT_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_ASSIGNMENT_ID
,      RESOURCE_TYPE
,      RESOURCE_TYPE_MEANING
,      RESOURCE_ID
,      RESOURCE_NAME
,      ADDRESS_TYPE
FROM APPS.CSP_REQUIRED_PARTS_V;

Dependencies

[top of page]

APPS.CSP_REQUIRED_PARTS_V references the following:

SchemaAPPS
ViewCSP_PART_PRIORITIES_V
PL/SQL PackageCSP_PICK_UTILS - show dependent code
SynonymCSP_REQUIREMENT_HEADERS
SynonymCSP_REQUIREMENT_LINES
SynonymCSP_REQ_LINE_DETAILS
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewJTF_OBJECTS_VL
ViewJTF_TASKS_VL
SynonymJTF_TASK_ASSIGNMENTS
SynonymMTL_PARAMETERS
SynonymMTL_RESERVATIONS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymORG_FREIGHT
SynonymPO_HEADERS
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES

APPS.CSP_REQUIRED_PARTS_V is not referenced by any database object