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

VIEW: PON.PON_EMD_FIN_PARAMETERS_ALL#

Object Details
Object Name: PON_EMD_FIN_PARAMETERS_ALL#
Object Type: VIEW
Owner: PON
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

RA_TRX_TYPE_ID NUMBER (15)
RA_BATCH_SOURCE_ID NUMBER (15)
MEMO_LINE_ID NUMBER (15)
EMD_FINANCE_INTEGRATION VARCHAR2 (1)
PAYMENT_TERMS_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_UPDATE_DATE DATE

CORPORATE_EMD_BANK_ACCOUNT VARCHAR2 (100)
EMD_FIN_PARAMETERS_ID NUMBER
Yes
DEFAULT_EMD_AMOUNT NUMBER (15)
RA_IMPORT_BATCH_SOURCE_ID NUMBER (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
MEMO_LINE_INVOICE_ID NUMBER (15)
Query Text

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


SELECT ORG_ID
,      RA_TRX_TYPE_ID
,      RA_BATCH_SOURCE_ID
,      MEMO_LINE_ID
,      EMD_FINANCE_INTEGRATION
,      PAYMENT_TERMS_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      CORPORATE_EMD_BANK_ACCOUNT
,      EMD_FIN_PARAMETERS_ID
,      DEFAULT_EMD_AMOUNT
,      RA_IMPORT_BATCH_SOURCE_ID
,      EXCHANGE_RATE_TYPE
,      MEMO_LINE_INVOICE_ID
FROM PON.PON_EMD_FIN_PARAMETERS_ALL#;

Dependencies

[top of page]

PON.PON_EMD_FIN_PARAMETERS_ALL# references the following:

SchemaPON
TablePON_EMD_FIN_PARAMETERS_ALL
PON.PON_EMD_FIN_PARAMETERS_ALL# is referenced by following:

SchemaAPPS
SynonymPON_EMD_FIN_PARAMETERS_ALL