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

VIEW: JMF.JMF_SUBCONTRACT_ORDERS#

Object Details
Object Name: JMF_SUBCONTRACT_ORDERS#
Object Type: VIEW
Owner: JMF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SUBCONTRACT_PO_SHIPMENT_ID NUMBER
Yes
SUBCONTRACT_PO_HEADER_ID NUMBER
Yes
SUBCONTRACT_PO_LINE_ID NUMBER
Yes
PROJECT_ID NUMBER

TASK_ID NUMBER

OEM_ORGANIZATION_ID NUMBER
Yes
TP_ORGANIZATION_ID NUMBER
Yes
WIP_ENTITY_ID NUMBER

OSA_ITEM_ID NUMBER
Yes
OSA_ITEM_PRICE NUMBER

NEED_BY_DATE DATE

UOM VARCHAR2 (3)
CURRENCY VARCHAR2 (15)
QUANTITY NUMBER

INTERLOCK_STATUS VARCHAR2 (1)
BATCH_ID NUMBER

REQUEST_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER

Query Text

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


SELECT SUBCONTRACT_PO_SHIPMENT_ID
,      SUBCONTRACT_PO_HEADER_ID
,      SUBCONTRACT_PO_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      OEM_ORGANIZATION_ID
,      TP_ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OSA_ITEM_ID
,      OSA_ITEM_PRICE
,      NEED_BY_DATE
,      UOM
,      CURRENCY
,      QUANTITY
,      INTERLOCK_STATUS
,      BATCH_ID
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
FROM JMF.JMF_SUBCONTRACT_ORDERS#;

Dependencies

[top of page]

JMF.JMF_SUBCONTRACT_ORDERS# references the following:

SchemaJMF
TableJMF_SUBCONTRACT_ORDERS
JMF.JMF_SUBCONTRACT_ORDERS# is referenced by following:

SchemaAPPS
SynonymJMF_SUBCONTRACT_ORDERS