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


VIEW: APPS.JAI_RGM_ORG_REGNS_V

Object Details
Object Name: JAI_RGM_ORG_REGNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_RGM_ORG_REGNS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGIME_ID NUMBER (15)
REGIME_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
EFFECTIVE_DATE_FROM DATE

EFFECTIVE_DATE_TO DATE

REGIME_ORG_ID NUMBER (15)
ORGANIZATION_TYPE VARCHAR2 (3)
ORGANIZATION_ID NUMBER (15)
LOCATION_ID NUMBER (15)
AUTHORITY_ID NUMBER (15)
AUTHORITY_SITE_ID NUMBER (15)
REGISTRATION_ID NUMBER (15)
REGISTRATION_TYPE VARCHAR2 (30)
ATTRIBUTE_SEQUENCE NUMBER (9)
ATTRIBUTE_TYPE_CODE VARCHAR2 (30)
ATTRIBUTE_CODE VARCHAR2 (80)
ATTRIBUTE_VALUE VARCHAR2 (240)
PARENT_REGISTRATION_ID NUMBER (15)
RATE NUMBER (17)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
Query Text

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


SELECT REGIME_ID
,      REGIME_CODE
,      DESCRIPTION
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      REGIME_ORG_ID
,      ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      LOCATION_ID
,      AUTHORITY_ID
,      AUTHORITY_SITE_ID
,      REGISTRATION_ID
,      REGISTRATION_TYPE
,      ATTRIBUTE_SEQUENCE
,      ATTRIBUTE_TYPE_CODE
,      ATTRIBUTE_CODE
,      ATTRIBUTE_VALUE
,      PARENT_REGISTRATION_ID
,      RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.JAI_RGM_ORG_REGNS_V;

Dependencies

[top of page]

APPS.JAI_RGM_ORG_REGNS_V references the following:

SchemaAPPS
SynonymJAI_RGM_DEFINITIONS
SynonymJAI_RGM_PARTIES
SynonymJAI_RGM_PARTY_REGNS
SynonymJAI_RGM_REGISTRATIONS
APPS.JAI_RGM_ORG_REGNS_V is referenced by following:

SchemaAPPS
Package BodyJAI_AP_DTC_DEFAULTATION_PKG - show dependent code
Package BodyJAI_AP_DTC_GENERATION_PKG - show dependent code
Package BodyJAI_AP_IDA_TRIGGER_PKG - show dependent code
Package BodyJAI_AP_STND_TAX_PROCESS - show dependent code
Package BodyJAI_AP_TDS_ETDS_PKG - show dependent code
Package BodyJAI_AP_TDS_GENERATION_PKG - show dependent code
ViewJAI_AP_TDS_ORG_TAN_V
Package BodyJAI_AP_TDS_POP_RPST_PKG - show dependent code
Package BodyJAI_AP_TDS_TAX_DEFAULTATION - show dependent code
Package BodyJAI_AP_UTILS_PKG - show dependent code
Package BodyJAI_AR_EER1_PKG - show dependent code
Package BodyJAI_AR_GLDIST_TRIGGER_PKG - show dependent code
Package BodyJAI_AR_IMPORT_SYNC_PKG - show dependent code
Package BodyJAI_AR_MATCH_TAX_PKG - show dependent code
Package BodyJAI_AR_RCTA_TRIGGER_PKG - show dependent code
Package BodyJAI_AR_RGM_PROCESSING_PKG - show dependent code
PL/SQL PackageJAI_AR_TCS_REP_PKG - show dependent code
Package BodyJAI_AR_TRX_HEADERS_PKG - show dependent code
Package BodyJAI_AR_TRX_PKG - show dependent code
Package BodyJAI_CMN_REVERSE_CHARGE_PKG - show dependent code
Package BodyJAI_CMN_RGM_PROCESSING_PKG - show dependent code
Package BodyJAI_CMN_RGM_RECORDING_PKG - show dependent code
Package BodyJAI_CMN_RGM_SETUP_PKG - show dependent code
Package BodyJAI_CMN_RGM_TAX_DIST_PKG - show dependent code
Package BodyJAI_CMN_RGM_TERMS_PKG - show dependent code
Package BodyJAI_CMN_UTILS_PKG - show dependent code
Package BodyJAI_ETCS_PKG - show dependent code
Package BodyJAI_GST_GENERAL_PKG - show dependent code
Package BodyJAI_JAP_TY_TRIGGER_PKG - show dependent code
Package BodyJAI_JAR_TL_TRIGGER_PKG - show dependent code
Package BodyJAI_OE_OLA_TRIGGER_PKG - show dependent code
Package BodyJAI_OM_WDD_PROCESSING_PKG - show dependent code
Package BodyJAI_OM_WDD_TRIGGER_PKG - show dependent code
Package BodyJAI_OPEN_API_PKG - show dependent code
Package BodyJAI_PA_BILLING_PKG - show dependent code
Package BodyJAI_RCV_RGM_CLAIMS_PKG - show dependent code
Package BodyJAI_RGM_GST_ACCOUNTING_PKG - show dependent code
Package BodyJAI_RGM_THHOLD_PROC_PKG - show dependent code
Package BodyJAI_ST_REVERSAL_EXTRACT_PKG - show dependent code
Package BodyJAI_TAX_PROCESSING_PKG - show dependent code
Package BodyJAI_TRX_REPO_EXTRACT_PKG - show dependent code
Package BodyJA_JAINER1_XMLP_PKG - show dependent code
Package BodyJA_JAINRGCR_XMLP_PKG - show dependent code
Package BodyJA_JAINST3_XMLP_PKG - show dependent code
Package BodyJA_JAINVATR_XMLP_PKG - show dependent code