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

VIEW: APPS.POS_ORG_ADDRESS_V

Object Details
Object Name: POS_ORG_ADDRESS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_ORG_ADDRESS_V
ViewPOS.POS_ORG_ADDRESS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used to fetch address information from the mtl_organizations view


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes Organization Id
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Name
ADDRESS1 VARCHAR2 (240)
Address
ADDRESS2 VARCHAR2 (240)
Address
ADDRESS3 VARCHAR2 (240)
Address
CITY VARCHAR2 (30)
City
STATE VARCHAR2 (120)
State
COUNTRY VARCHAR2 (60)
Country
ZIP_CODE VARCHAR2 (30)
Zip Code
CITY_STATE_ZIP VARCHAR2 (188)
City State and Zip
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books
SET_OF_BOOKS_NAME VARCHAR2 (30) Yes Set of Books Name
SYMBOL VARCHAR2 (12)
Currency Symbol
ORG_INFO VARCHAR2 (1286)
Organization Info
VALUE NUMBER

Not Used
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      CITY
,      STATE
,      COUNTRY
,      ZIP_CODE
,      CITY_STATE_ZIP
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      SYMBOL
,      ORG_INFO
,      VALUE
FROM APPS.POS_ORG_ADDRESS_V;

Dependencies

[top of page]

APPS.POS_ORG_ADDRESS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMTL_ORGANIZATIONS

APPS.POS_ORG_ADDRESS_V is not referenced by any database object