eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: JE.JE_ES_MODELO_190_ALL#

Object Details

Object Name:	JE_ES_MODELO_190_ALL#
Object Type:	VIEW
Owner:	JE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER
CONC_REQ_ID	NUMBER
FIN_IND	VARCHAR2	(1)	Yes
REMUN_TYPE	VARCHAR2	(1)	Yes
VENDOR_NIF	VARCHAR2	(9)	Yes
VENDOR_NAME	VARCHAR2	(240)	Yes
INVOICE_ID	NUMBER
INVOICE_NUM	VARCHAR2	(50)
INV_DOC_SEQ_NUM	VARCHAR2	(100)
INVOICE_DATE	DATE
GL_DATE	DATE
INVOICE_PAYMENT_ID	NUMBER
DATE_PAID	DATE
NET_AMOUNT	NUMBER		Yes
WITHHOLDING_TAX_AMOUNT	NUMBER		Yes
ZIP_ELECTRONIC	VARCHAR2	(5)
ZIP_LEGAL	VARCHAR2	(5)
CITY_LEGAL	VARCHAR2	(25)
NUM_CHILDREN	NUMBER
SIGN	VARCHAR2	(1)
TAX_RATE	NUMBER
TAX_NAME	VARCHAR2	(15)
YEAR_DUE	NUMBER
SUB_REMUN_TYPE	VARCHAR2	(2)
WITHHOLDABLE_AMT_IN_KIND	NUMBER
WITHHOLDABLE_AMT_IN_KIND_SIGN	VARCHAR2	(1)
WITHHELD_AMT_IN_KIND	NUMBER
WITHHELD_PYMT_AMT_IN_KIND	NUMBER
EARNED_AMOUNTS	NUMBER
CONTRACT_TYPE	NUMBER
BIRTH_YEAR	NUMBER
DISABLED	NUMBER
FAMILY_SITUATION	NUMBER
PARTNER_FISCAL_CODE	VARCHAR2	(15)
DESCENDANT_LT_3	NUMBER
DESCENDANT_BT_3_16	NUMBER
DESCENDANT_BT_16_25	NUMBER
DISABLE_DESC_BT_33_65	NUMBER
DISABLE_DESC_GT_65	NUMBER
DESCENDANT_TOTAL	NUMBER
DEDUCTIONS	NUMBER
EXPENSES	NUMBER
SPOUSE_MAINTENANCE_AMT	NUMBER
CHILDREN_MAINTENANCE_AMT	NUMBER
LEGAL_ENTITY_ID	NUMBER

Query Text

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


SELECT ORG_ID
,      CONC_REQ_ID
,      FIN_IND
,      REMUN_TYPE
,      VENDOR_NIF
,      VENDOR_NAME
,      INVOICE_ID
,      INVOICE_NUM
,      INV_DOC_SEQ_NUM
,      INVOICE_DATE
,      GL_DATE
,      INVOICE_PAYMENT_ID
,      DATE_PAID
,      NET_AMOUNT
,      WITHHOLDING_TAX_AMOUNT
,      ZIP_ELECTRONIC
,      ZIP_LEGAL
,      CITY_LEGAL
,      NUM_CHILDREN
,      SIGN
,      TAX_RATE
,      TAX_NAME
,      YEAR_DUE
,      SUB_REMUN_TYPE
,      WITHHOLDABLE_AMT_IN_KIND
,      WITHHOLDABLE_AMT_IN_KIND_SIGN
,      WITHHELD_AMT_IN_KIND
,      WITHHELD_PYMT_AMT_IN_KIND
,      EARNED_AMOUNTS
,      CONTRACT_TYPE
,      BIRTH_YEAR
,      DISABLED
,      FAMILY_SITUATION
,      PARTNER_FISCAL_CODE
,      DESCENDANT_LT_3
,      DESCENDANT_BT_3_16
,      DESCENDANT_BT_16_25
,      DISABLE_DESC_BT_33_65
,      DISABLE_DESC_GT_65
,      DESCENDANT_TOTAL
,      DEDUCTIONS
,      EXPENSES
,      SPOUSE_MAINTENANCE_AMT
,      CHILDREN_MAINTENANCE_AMT
,      LEGAL_ENTITY_ID
FROM JE.JE_ES_MODELO_190_ALL#;

Dependencies

[top of page]

JE.JE_ES_MODELO_190_ALL# references the following:

JE: JE_ES_MODELO_190_ALL

JE.JE_ES_MODELO_190_ALL# is referenced by following:

APPS: JE_ES_MODELO_190_ALL