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

VIEW: JA.JAI_AP_TDS_THHOLD_GRPS#

Object Details
Object Name: JAI_AP_TDS_THHOLD_GRPS#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
THRESHOLD_GRP_ID NUMBER (15) Yes
VENDOR_ID NUMBER (15) Yes
ORG_TAN_NUM VARCHAR2 (30) Yes
VENDOR_PAN_NUM VARCHAR2 (30) Yes
SECTION_TYPE VARCHAR2 (30) Yes
SECTION_CODE VARCHAR2 (30) Yes
FIN_YEAR NUMBER (9) Yes
TOTAL_INVOICE_AMOUNT NUMBER

TOTAL_INVOICE_CANCEL_AMOUNT NUMBER

TOTAL_INVOICE_APPLY_AMOUNT NUMBER

TOTAL_INVOICE_UNAPPLY_AMOUNT NUMBER

TOTAL_TAX_PAID NUMBER

TOTAL_THHOLD_CHANGE_TAX_PAID NUMBER

CURRENT_THRESHOLD_SLAB_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
CUSTOMER_TYPE_LOOKUP_CODE VARCHAR2 (30)
REGIME_ID NUMBER (22)
TOTAL_CALC_TAX_PAID NUMBER

THRESHOLD_HDR_ID NUMBER

Query Text

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


SELECT THRESHOLD_GRP_ID
,      VENDOR_ID
,      ORG_TAN_NUM
,      VENDOR_PAN_NUM
,      SECTION_TYPE
,      SECTION_CODE
,      FIN_YEAR
,      TOTAL_INVOICE_AMOUNT
,      TOTAL_INVOICE_CANCEL_AMOUNT
,      TOTAL_INVOICE_APPLY_AMOUNT
,      TOTAL_INVOICE_UNAPPLY_AMOUNT
,      TOTAL_TAX_PAID
,      TOTAL_THHOLD_CHANGE_TAX_PAID
,      CURRENT_THRESHOLD_SLAB_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CUSTOMER_TYPE_LOOKUP_CODE
,      REGIME_ID
,      TOTAL_CALC_TAX_PAID
,      THRESHOLD_HDR_ID
FROM JA.JAI_AP_TDS_THHOLD_GRPS#;

Dependencies

[top of page]

JA.JAI_AP_TDS_THHOLD_GRPS# references the following:

SchemaJA
TableJAI_AP_TDS_THHOLD_GRPS
JA.JAI_AP_TDS_THHOLD_GRPS# is referenced by following:

SchemaAPPS
SynonymJAI_AP_TDS_THHOLD_GRPS