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

VIEW: APPS.JAI_CMN_PLA_REGISTER_V

Object Details
Object Name: JAI_CMN_PLA_REGISTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_CMN_PLA_REGISTER_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
ROW_ID ROWID (10)
NAME VARCHAR2 (240) Yes
ORGANIZATION_CODE VARCHAR2 (3)
LOCATION_CODE VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (240)
SLNO NUMBER (15) Yes
TRANSACTION_DATE DATE

BAISC_ED NUMBER

ORGANIZATION_ID NUMBER

LOCATION_ID NUMBER

ADDITIONAL_ED NUMBER

OTHER_ED NUMBER

OPENING_BALANCE NUMBER

CLOSING_BALANCE NUMBER

INVOICE_ID VARCHAR2 (50)
REF_DOCUMENT_ID NUMBER (15)
FIN_YEAR NUMBER (9)
REGISTER_ID NUMBER
Yes
VENDOR_CUST_FLAG VARCHAR2 (1)
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      NAME
,      ORGANIZATION_CODE
,      LOCATION_CODE
,      DESCRIPTION
,      SLNO
,      TRANSACTION_DATE
,      BAISC_ED
,      ORGANIZATION_ID
,      LOCATION_ID
,      ADDITIONAL_ED
,      OTHER_ED
,      OPENING_BALANCE
,      CLOSING_BALANCE
,      INVOICE_ID
,      REF_DOCUMENT_ID
,      FIN_YEAR
,      REGISTER_ID
,      VENDOR_CUST_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
FROM APPS.JAI_CMN_PLA_REGISTER_V;

Dependencies

[top of page]

APPS.JAI_CMN_PLA_REGISTER_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymJAI_CMN_INVENTORY_ORGS
SynonymJAI_CMN_RG_PLA_TRXS
ViewORG_ORGANIZATION_DEFINITIONS

APPS.JAI_CMN_PLA_REGISTER_V is not referenced by any database object