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

TABLE: ZX.ZX_PTNR_LOCATION_INFO_GT

Object Details
Object Name: ZX_PTNR_LOCATION_INFO_GT
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_PTNR_LOCATION_INFO_GT
Subobject Name:
Status: VALID

Temporary Table Details

ZX.ZX_PTNR_LOCATION_INFO_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
ZX_PTNR_LOCATION_INFO_GT_U1 NORMAL NONUNIQUE Tablespace ColumnEVENT_CLASS_MAPPING_ID
ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LEVEL_TYPE
Columns
Name Datatype Length Mandatory Comments
EVENT_CLASS_MAPPING_ID NUMBER (15) Yes Event class mapping identifier
TRX_ID NUMBER
Yes Primary transaction identifier
TRX_LINE_ID NUMBER
Yes Transaction line identifier
SHIP_TO_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Ship To location
SHIP_FROM_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Ship from location
POA_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Point of Order Acceptance
POA_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Point of Order Acceptance
POA_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Point of Order Acceptance
POO_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Point of Order Origin
POO_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Point of Order Origin
POO_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Point of Order Origin
POO_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Point of Order Origin
POO_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Point of Order Origin
POO_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Point of Order Origin
POO_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Point of Order Origin
POO_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Point of Order Origin
POO_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Point of Order Origin
POO_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Point of Order Origin
POO_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Point of Order Origin
POO_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Point of Order Origin
POO_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Point of Order Origin
POO_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Point of Order Origin
POO_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Point of Order Origin
BILL_TO_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Bill To location
BILL_FROM_GEOGRAPHY_TYPE1 VARCHAR2 (240)
Geography type of the first element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE1 VARCHAR2 (240)
Geography name of the first element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE2 VARCHAR2 (240)
Geography type of the second element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE2 VARCHAR2 (240)
Geography name of the second element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE3 VARCHAR2 (240)
Geography type of the third element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE3 VARCHAR2 (240)
Geography name of the third element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE4 VARCHAR2 (240)
Geography type of the fourth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE4 VARCHAR2 (240)
Geography name of the fourth element of the Bill from location
BILL_FROM_GEOGRAPHY_TYPE5 VARCHAR2 (240)
Geography type of the fifth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE5 VARCHAR2 (240)
Geography name of the fifth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE6 VARCHAR2 (240)
Geography type of the sixth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE6 VARCHAR2 (240)
Geography name of the sixth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE7 VARCHAR2 (240)
Geography type of the seventh element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE7 VARCHAR2 (240)
Geography name of the seventh element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE8 VARCHAR2 (240)
Geography type of the eighth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE8 VARCHAR2 (240)
Geography name of the eighth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE9 VARCHAR2 (240)
Geography type of the nineth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE9 VARCHAR2 (240)
Geography name of the nineth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE10 VARCHAR2 (240)
Geography type of the tenth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE10 VARCHAR2 (240)
Geography name of the tenth element of the Bill From location
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
SHIP_TO_PARTY_NUMBER VARCHAR2 (30)
Number of the ship to party
SHIP_TO_PARTY_NAME VARCHAR2 (360)
Name of the ship to party
SHIP_FROM_PARTY_NUMBER VARCHAR2 (30)
Number of the ship from party
SHIP_FROM_PARTY_NAME VARCHAR2 (360)
Name of the ship from party
BILL_TO_PARTY_NUMBER VARCHAR2 (30)
Number of the bill to party
BILL_TO_PARTY_NAME VARCHAR2 (360)
Name of the bill to party
BILL_FROM_PARTY_NUMBER VARCHAR2 (30)
Number of the bill from party
BILL_FROM_PARTY_NAME VARCHAR2 (360)
Name of the bill from party
Query Text

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


SELECT EVENT_CLASS_MAPPING_ID
,      TRX_ID
,      TRX_LINE_ID
,      SHIP_TO_GEOGRAPHY_TYPE1
,      SHIP_TO_GEOGRAPHY_VALUE1
,      SHIP_TO_GEOGRAPHY_TYPE2
,      SHIP_TO_GEOGRAPHY_VALUE2
,      SHIP_TO_GEOGRAPHY_TYPE3
,      SHIP_TO_GEOGRAPHY_VALUE3
,      SHIP_TO_GEOGRAPHY_TYPE4
,      SHIP_TO_GEOGRAPHY_VALUE4
,      SHIP_TO_GEOGRAPHY_TYPE5
,      SHIP_TO_GEOGRAPHY_VALUE5
,      SHIP_TO_GEOGRAPHY_TYPE6
,      SHIP_TO_GEOGRAPHY_VALUE6
,      SHIP_TO_GEOGRAPHY_TYPE7
,      SHIP_TO_GEOGRAPHY_VALUE7
,      SHIP_TO_GEOGRAPHY_TYPE8
,      SHIP_TO_GEOGRAPHY_VALUE8
,      SHIP_TO_GEOGRAPHY_TYPE9
,      SHIP_TO_GEOGRAPHY_VALUE9
,      SHIP_TO_GEOGRAPHY_TYPE10
,      SHIP_TO_GEOGRAPHY_VALUE10
,      SHIP_FROM_GEOGRAPHY_TYPE1
,      SHIP_FROM_GEOGRAPHY_VALUE1
,      SHIP_FROM_GEOGRAPHY_TYPE2
,      SHIP_FROM_GEOGRAPHY_VALUE2
,      SHIP_FROM_GEOGRAPHY_TYPE3
,      SHIP_FROM_GEOGRAPHY_VALUE3
,      SHIP_FROM_GEOGRAPHY_TYPE4
,      SHIP_FROM_GEOGRAPHY_VALUE4
,      SHIP_FROM_GEOGRAPHY_TYPE5
,      SHIP_FROM_GEOGRAPHY_VALUE5
,      SHIP_FROM_GEOGRAPHY_TYPE6
,      SHIP_FROM_GEOGRAPHY_VALUE6
,      SHIP_FROM_GEOGRAPHY_TYPE7
,      SHIP_FROM_GEOGRAPHY_VALUE7
,      SHIP_FROM_GEOGRAPHY_TYPE8
,      SHIP_FROM_GEOGRAPHY_VALUE8
,      SHIP_FROM_GEOGRAPHY_TYPE9
,      SHIP_FROM_GEOGRAPHY_VALUE9
,      SHIP_FROM_GEOGRAPHY_TYPE10
,      SHIP_FROM_GEOGRAPHY_VALUE10
,      POA_GEOGRAPHY_TYPE1
,      POA_GEOGRAPHY_VALUE1
,      POA_GEOGRAPHY_TYPE2
,      POA_GEOGRAPHY_VALUE2
,      POA_GEOGRAPHY_TYPE3
,      POA_GEOGRAPHY_VALUE3
,      POA_GEOGRAPHY_TYPE4
,      POA_GEOGRAPHY_VALUE4
,      POA_GEOGRAPHY_TYPE5
,      POA_GEOGRAPHY_VALUE5
,      POA_GEOGRAPHY_TYPE6
,      POA_GEOGRAPHY_VALUE6
,      POA_GEOGRAPHY_TYPE7
,      POA_GEOGRAPHY_VALUE7
,      POA_GEOGRAPHY_TYPE8
,      POA_GEOGRAPHY_VALUE8
,      POA_GEOGRAPHY_TYPE9
,      POA_GEOGRAPHY_VALUE9
,      POA_GEOGRAPHY_TYPE10
,      POA_GEOGRAPHY_VALUE10
,      POO_GEOGRAPHY_TYPE1
,      POO_GEOGRAPHY_VALUE1
,      POO_GEOGRAPHY_TYPE2
,      POO_GEOGRAPHY_VALUE2
,      POO_GEOGRAPHY_TYPE3
,      POO_GEOGRAPHY_VALUE3
,      POO_GEOGRAPHY_TYPE4
,      POO_GEOGRAPHY_VALUE4
,      POO_GEOGRAPHY_TYPE5
,      POO_GEOGRAPHY_VALUE5
,      POO_GEOGRAPHY_TYPE6
,      POO_GEOGRAPHY_VALUE6
,      POO_GEOGRAPHY_TYPE7
,      POO_GEOGRAPHY_VALUE7
,      POO_GEOGRAPHY_TYPE8
,      POO_GEOGRAPHY_VALUE8
,      POO_GEOGRAPHY_TYPE9
,      POO_GEOGRAPHY_VALUE9
,      POO_GEOGRAPHY_TYPE10
,      POO_GEOGRAPHY_VALUE10
,      BILL_TO_GEOGRAPHY_TYPE1
,      BILL_TO_GEOGRAPHY_VALUE1
,      BILL_TO_GEOGRAPHY_TYPE2
,      BILL_TO_GEOGRAPHY_VALUE2
,      BILL_TO_GEOGRAPHY_TYPE3
,      BILL_TO_GEOGRAPHY_VALUE3
,      BILL_TO_GEOGRAPHY_TYPE4
,      BILL_TO_GEOGRAPHY_VALUE4
,      BILL_TO_GEOGRAPHY_TYPE5
,      BILL_TO_GEOGRAPHY_VALUE5
,      BILL_TO_GEOGRAPHY_TYPE6
,      BILL_TO_GEOGRAPHY_VALUE6
,      BILL_TO_GEOGRAPHY_TYPE7
,      BILL_TO_GEOGRAPHY_VALUE7
,      BILL_TO_GEOGRAPHY_TYPE8
,      BILL_TO_GEOGRAPHY_VALUE8
,      BILL_TO_GEOGRAPHY_TYPE9
,      BILL_TO_GEOGRAPHY_VALUE9
,      BILL_TO_GEOGRAPHY_TYPE10
,      BILL_TO_GEOGRAPHY_VALUE10
,      BILL_FROM_GEOGRAPHY_TYPE1
,      BILL_FROM_GEOGRAPHY_VALUE1
,      BILL_FROM_GEOGRAPHY_TYPE2
,      BILL_FROM_GEOGRAPHY_VALUE2
,      BILL_FROM_GEOGRAPHY_TYPE3
,      BILL_FROM_GEOGRAPHY_VALUE3
,      BILL_FROM_GEOGRAPHY_TYPE4
,      BILL_FROM_GEOGRAPHY_VALUE4
,      BILL_FROM_GEOGRAPHY_TYPE5
,      BILL_FROM_GEOGRAPHY_VALUE5
,      BILL_FROM_GEOGRAPHY_TYPE6
,      BILL_FROM_GEOGRAPHY_VALUE6
,      BILL_FROM_GEOGRAPHY_TYPE7
,      BILL_FROM_GEOGRAPHY_VALUE7
,      BILL_FROM_GEOGRAPHY_TYPE8
,      BILL_FROM_GEOGRAPHY_VALUE8
,      BILL_FROM_GEOGRAPHY_TYPE9
,      BILL_FROM_GEOGRAPHY_VALUE9
,      BILL_FROM_GEOGRAPHY_TYPE10
,      BILL_FROM_GEOGRAPHY_VALUE10
,      TRX_LEVEL_TYPE
,      SHIP_TO_PARTY_NUMBER
,      SHIP_TO_PARTY_NAME
,      SHIP_FROM_PARTY_NUMBER
,      SHIP_FROM_PARTY_NAME
,      BILL_TO_PARTY_NUMBER
,      BILL_TO_PARTY_NAME
,      BILL_FROM_PARTY_NUMBER
,      BILL_FROM_PARTY_NAME
FROM ZX.ZX_PTNR_LOCATION_INFO_GT;

Dependencies

[top of page]

ZX.ZX_PTNR_LOCATION_INFO_GT does not reference any database object

ZX.ZX_PTNR_LOCATION_INFO_GT is referenced by following:

SchemaAPPS
SynonymZX_PTNR_LOCATION_INFO_GT