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

VIEW: JA.JAI_OPM_OSP_HDRS#

Object Details
Object Name: JAI_OPM_OSP_HDRS#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OSP_HEADER_ID NUMBER (15) Yes
PO_ID NUMBER (15)
TRANSACTION_DATE DATE

USER_REFERENCE VARCHAR2 (40) Yes
TOT_MODVAT_CLAIMED NUMBER

TOT_EXCISE_PAID NUMBER

FINAL_RECEIPT VARCHAR2 (2)
ORIGINAL_DUE_DATE DATE

EXTENDED_DUE_DATE DATE

RECEIVABLE_EXCISE NUMBER

PAYABLE_EXCISE NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

REGISTER_SELECTED VARCHAR2 (20)
BATCH_STATUS NUMBER (9)
BATCH_CLOSE_DATE DATE

FORM_NAME VARCHAR2 (20)
ORGN_CODE VARCHAR2 (4)
WHSE_CODE VARCHAR2 (15) Yes
POST_RG23_II VARCHAR2 (2)
FIN_YEAR NUMBER (9)
FORM_NUMBER NUMBER

OBJECT_VERSION_NUMBER NUMBER (9)
FORMULA_ID_REF NUMBER (15)
ORGANIZATION_ID NUMBER (15)
Query Text

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


SELECT OSP_HEADER_ID
,      PO_ID
,      TRANSACTION_DATE
,      USER_REFERENCE
,      TOT_MODVAT_CLAIMED
,      TOT_EXCISE_PAID
,      FINAL_RECEIPT
,      ORIGINAL_DUE_DATE
,      EXTENDED_DUE_DATE
,      RECEIVABLE_EXCISE
,      PAYABLE_EXCISE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REGISTER_SELECTED
,      BATCH_STATUS
,      BATCH_CLOSE_DATE
,      FORM_NAME
,      ORGN_CODE
,      WHSE_CODE
,      POST_RG23_II
,      FIN_YEAR
,      FORM_NUMBER
,      OBJECT_VERSION_NUMBER
,      FORMULA_ID_REF
,      ORGANIZATION_ID
FROM JA.JAI_OPM_OSP_HDRS#;

Dependencies

[top of page]

JA.JAI_OPM_OSP_HDRS# references the following:

SchemaJA
TableJAI_OPM_OSP_HDRS
JA.JAI_OPM_OSP_HDRS# is referenced by following:

SchemaAPPS
SynonymJAI_OPM_OSP_HDRS