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

VIEW: APPS.PO_VENDORS1_DFV

Object Details
Object Name: PO_VENDORS1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
UNIFORM_NUMBER VARCHAR2 (150)
GUI_TYPE VARCHAR2 (150)
JE_GR_PSC_YES_NO VARCHAR2 (150)
DATE_OF_BIRTH DATE

PLACE_OF_BIRTH VARCHAR2 (150)
ORIGIN VARCHAR2 (150)
TAXPAYER_ID_TYPE VARCHAR2 (150)
TAXPAYER_ID_VALIDATION_DIGIT NUMBER

MULTILATERAL_CONTRIBUTER VARCHAR2 (150)
TRANSACTION_LETTER VARCHAR2 (150)
VAT_REG_STATUS_CODE VARCHAR2 (150)
COLLECTION_DOC_ASSOCIATION VARCHAR2 (150)
INTEREST_TYPE VARCHAR2 (150)
INTEREST_RATE_AMOUNT NUMBER

INTEREST_PERIOD NUMBER

INTEREST_FORMULA VARCHAR2 (150)
INTEREST_GRACE_DAYS NUMBER

INTEREST_PENALTY_TYPE VARCHAR2 (150)
INTEREST_PENALTY_RATE_AMOUNT NUMBER

TAXPAYER_ID_VALIDATION_DIGIT_C VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (1238)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      UNIFORM_NUMBER
,      GUI_TYPE
,      JE_GR_PSC_YES_NO
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      ORIGIN
,      TAXPAYER_ID_TYPE
,      TAXPAYER_ID_VALIDATION_DIGIT
,      MULTILATERAL_CONTRIBUTER
,      TRANSACTION_LETTER
,      VAT_REG_STATUS_CODE
,      COLLECTION_DOC_ASSOCIATION
,      INTEREST_TYPE
,      INTEREST_RATE_AMOUNT
,      INTEREST_PERIOD
,      INTEREST_FORMULA
,      INTEREST_GRACE_DAYS
,      INTEREST_PENALTY_TYPE
,      INTEREST_PENALTY_RATE_AMOUNT
,      TAXPAYER_ID_VALIDATION_DIGIT_C
,      CONCATENATED_SEGMENTS
FROM APPS.PO_VENDORS1_DFV;

Dependencies

[top of page]

APPS.PO_VENDORS1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
ViewPO_VENDORS

APPS.PO_VENDORS1_DFV is not referenced by any database object