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.CSP_REQUIRED_PARTS_V

Object Details

Object Name:	CSP_REQUIRED_PARTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.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	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:

APPS: CSP_PART_PRIORITIES_V; CSP_PICK_UTILS - show dependent code; CSP_REQUIREMENT_HEADERS; CSP_REQUIREMENT_LINES; CSP_REQ_LINE_DETAILS; CS_STD - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_OBJECTS_VL; JTF_TASKS_VL; JTF_TASK_ASSIGNMENTS; MTL_PARAMETERS; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_B_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; ORG_FREIGHT; PO_HEADERS; PO_LINE_LOCATIONS_ALL; PO_LOOKUP_CODES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES

APPS.CSP_REQUIRED_PARTS_V is not referenced by any database object