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


VIEW: APPS.OKE_DELIVERABLE_PURCHASING_V

Object Details
Object Name: OKE_DELIVERABLE_PURCHASING_V
Object Type: VIEW
Owner: APPS
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
SOURCE_HEADER_ID NUMBER

Contract document unique identifier
SOURCE_DELIVERABLE_ID NUMBER

Contract document line item unique identifier
ACTION_ID NUMBER

Contract deliverable unique identifier
PROJECT_ID NUMBER

System generated project unique identifier
TASK_ID NUMBER

System generated task unique identifier
PO_HEADER_ID NUMBER
Yes Purchase order unique identifier
PO_LINE_ID NUMBER
Yes Purchase order line unique identifier
PO_LINE_LOCATION_ID NUMBER
Yes Purchase order shipment unique identifier
PO_NUMBER VARCHAR2 (20) Yes Purchase order number
PO_LINE_NUMBER NUMBER
Yes Purchase order line number
PO_SHIPMENT_NUMBER NUMBER

Purchase order shipment number
QUANTITY_ORDERED NUMBER

Quantity ordered
QUANTITY_DELIVERED NUMBER

Quantity delivered
QUANTITY_CANCELLED NUMBER

Quantity cancelled
UOM VARCHAR2 (25)
Unit of measure
BUYER VARCHAR2 (240)
Buyer
PO_NEED_BY_DATE DATE

Need by date
SUPPLIER_ID NUMBER

SUPPLIER_NAME VARCHAR2 (240)
SUPPLIER_NUMBER VARCHAR2 (30) Yes
SUPPLIER_SITE_ID NUMBER

SUPPLIER_SITE_CODE VARCHAR2 (15)
STATUS VARCHAR2 (80) Yes Purchase order status
RECEIVING_LOCATION VARCHAR2 (60)
Receiving location
Query Text

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


SELECT SOURCE_HEADER_ID
,      SOURCE_DELIVERABLE_ID
,      ACTION_ID
,      PROJECT_ID
,      TASK_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      QUANTITY_ORDERED
,      QUANTITY_DELIVERED
,      QUANTITY_CANCELLED
,      UOM
,      BUYER
,      PO_NEED_BY_DATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      STATUS
,      RECEIVING_LOCATION
FROM APPS.OKE_DELIVERABLE_PURCHASING_V;

Dependencies

[top of page]

APPS.OKE_DELIVERABLE_PURCHASING_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUP_VALUES_VL
SynonymHR_LOCATIONS_ALL
SynonymPER_ALL_PEOPLE_F
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.OKE_DELIVERABLE_PURCHASING_V is not referenced by any database object