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

VIEW: APPS.PA_TASK_CUSTOMERS_V

Object Details
Object Name: PA_TASK_CUSTOMERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TASK_CUSTOMERS_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
PROJECT_ID NUMBER (15) Yes
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_NUMBER VARCHAR2 (30) Yes
BILL_TO_CUSTOMER_ID NUMBER (15) Yes
SHIP_TO_CUSTOMER_ID NUMBER (15) Yes
BILL_TO_ADDRESS_ID NUMBER (15)
BILL_ADDRESS1 VARCHAR2 (240)
BILL_ADDRESS2 VARCHAR2 (240)
BILL_ADDRESS3 VARCHAR2 (240)
BILL_ADDRESS4 VARCHAR2 (489)
SHIP_TO_ADDRESS_ID NUMBER (15)
SHIP_ADDRESS1 VARCHAR2 (240)
SHIP_ADDRESS2 VARCHAR2 (240)
SHIP_ADDRESS3 VARCHAR2 (240)
SHIP_ADDRESS4 VARCHAR2 (489)
TASK_ID NUMBER (15) Yes
Query Text

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


SELECT PROJECT_ID
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      BILL_TO_ADDRESS_ID
,      BILL_ADDRESS1
,      BILL_ADDRESS2
,      BILL_ADDRESS3
,      BILL_ADDRESS4
,      SHIP_TO_ADDRESS_ID
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      TASK_ID
FROM APPS.PA_TASK_CUSTOMERS_V;

Dependencies

[top of page]

APPS.PA_TASK_CUSTOMERS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymPA_PROJECT_CUSTOMERS
SynonymPA_TASKS

APPS.PA_TASK_CUSTOMERS_V is not referenced by any database object