Skip to content

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)
ORGANIZATION_TYPE VARCHAR2 (150)
BOOK_KEEPING_CERTIFICATE VARCHAR2 (150)
BOOK_KEEPING_EXPIRY_DATE DATE

TAX_OFFICER_NUMBER VARCHAR2 (150)
OCCUPATION_DESCRIPTION VARCHAR2 (150)
INCLUDE_IN_SHAAM_REPORTING VARCHAR2 (150)
WITHHOLDING_TAX_REPORT_GROUP VARCHAR2 (150)
DATE_OF_BIRTH DATE

PLACE_OF_BIRTH VARCHAR2 (150)
PROVINCE_CODE_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)
SIMPLIFIED_REG_CONT_TYPE 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
,      ORGANIZATION_TYPE
,      BOOK_KEEPING_CERTIFICATE
,      BOOK_KEEPING_EXPIRY_DATE
,      TAX_OFFICER_NUMBER
,      OCCUPATION_DESCRIPTION
,      INCLUDE_IN_SHAAM_REPORTING
,      WITHHOLDING_TAX_REPORT_GROUP
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      PROVINCE_CODE_OF_BIRTH
,      ORIGIN
,      TAXPAYER_ID_TYPE
,      TAXPAYER_ID_VALIDATION_DIGIT
,      MULTILATERAL_CONTRIBUTER
,      TRANSACTION_LETTER
,      VAT_REG_STATUS_CODE
,      SIMPLIFIED_REG_CONT_TYPE
,      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