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


VIEW: APPS.PO_VENDOR_SITES_ALL2_DFV

Object Details
Object Name: PO_VENDOR_SITES_ALL2_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)
INDUSTRY_CLASSIFICATION VARCHAR2 (150)
INDUSTRY_SUB_CLASSIFICATION VARCHAR2 (150)
TAXABLE_PERSON VARCHAR2 (150)
BUSINESS_INCOME_SUB_CATEGORY VARCHAR2 (150)
ORGANIZATION_TYPE VARCHAR2 (150)
BOOK_KEEPING_CERTIFICATE VARCHAR2 (150)
BOOK_KEEPING_EXPIRY_DATE DATE

TAX_OFFICER_NUMBER VARCHAR2 (150)
INCLUDE_IN_SHAAM_REPORTING VARCHAR2 (150)
WITHHOLDING_TAX_REPORT_GROUP VARCHAR2 (150)
OCCUPATION_DESCRIPTION VARCHAR2 (150)
JEIT_DOCUMENT_CATEGORY_NAME VARCHAR2 (150)
LEGAL_ADDRESS VARCHAR2 (150)
FISCAL_PRINTER VARCHAR2 (150)
CAI_NUMBER NUMBER

CAI_DUE_DATE DATE

COLLECTION_DOC_ASSOCIATION VARCHAR2 (150)
INTEREST_TYPE VARCHAR2 (150)
INTEREST_RATE_AMOUNT NUMBER

INTEREST_PERIOD NUMBER

INTEREST_FORMULA VARCHAR2 (150)
INTEREST_GRACE_DAYS NUMBER

PENALTY_TYPE VARCHAR2 (150)
PENALTY_RATE_AMOUNT NUMBER

INSCRIPTION_TYPE VARCHAR2 (150)
INSCRIPTION_NUMBER VARCHAR2 (150)
INSCRIPTION_BRANCH VARCHAR2 (150)
INSCRIPTION_DIGIT VARCHAR2 (150)
STATE_INSCRIPTION VARCHAR2 (150)
CITY_INSCRIPTION VARCHAR2 (150)
CONTRIBUTOR_TYPE VARCHAR2 (150)
TAX_CALENDAR VARCHAR2 (150)
SUFRAMA_INSCRIPTION_NUMBER VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (2597)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      INDUSTRY_CLASSIFICATION
,      INDUSTRY_SUB_CLASSIFICATION
,      TAXABLE_PERSON
,      BUSINESS_INCOME_SUB_CATEGORY
,      ORGANIZATION_TYPE
,      BOOK_KEEPING_CERTIFICATE
,      BOOK_KEEPING_EXPIRY_DATE
,      TAX_OFFICER_NUMBER
,      INCLUDE_IN_SHAAM_REPORTING
,      WITHHOLDING_TAX_REPORT_GROUP
,      OCCUPATION_DESCRIPTION
,      JEIT_DOCUMENT_CATEGORY_NAME
,      LEGAL_ADDRESS
,      FISCAL_PRINTER
,      CAI_NUMBER
,      CAI_DUE_DATE
,      COLLECTION_DOC_ASSOCIATION
,      INTEREST_TYPE
,      INTEREST_RATE_AMOUNT
,      INTEREST_PERIOD
,      INTEREST_FORMULA
,      INTEREST_GRACE_DAYS
,      PENALTY_TYPE
,      PENALTY_RATE_AMOUNT
,      INSCRIPTION_TYPE
,      INSCRIPTION_NUMBER
,      INSCRIPTION_BRANCH
,      INSCRIPTION_DIGIT
,      STATE_INSCRIPTION
,      CITY_INSCRIPTION
,      CONTRIBUTOR_TYPE
,      TAX_CALENDAR
,      SUFRAMA_INSCRIPTION_NUMBER
,      CONCATENATED_SEGMENTS
FROM APPS.PO_VENDOR_SITES_ALL2_DFV;

Dependencies

[top of page]

APPS.PO_VENDOR_SITES_ALL2_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_NUMBER - show dependent code
ViewPO_VENDOR_SITES_ALL

APPS.PO_VENDOR_SITES_ALL2_DFV is not referenced by any database object