[Home] [Help]
View: ASO_I_PARTIES_V
Product: | ASO - Order Capture |
Description: | based on hz_parties. this view retrieves party information |
Implementation/DBA Data: |
APPS.ASO_I_PARTIES_V
|
View Text
SELECT HP1.PARTY_ID
, HP1.PARTY_NUMBER
, HP1.PARTY_TYPE
, HP1.VALIDATED_FLAG
, ASO_SHIPMENT_PVT.GET_PARTY_NAME(HP1.PARTY_ID
, HP1.PARTY_TYPE) PARTY_NAME
, ASO_SHIPMENT_PVT.GET_PARTY_FIRST_NAME(HP1.PARTY_ID
, HP1.PARTY_TYPE) PERSON_FIRST_NAME
, ASO_SHIPMENT_PVT.GET_PARTY_MID_NAME(HP1.PARTY_ID
, HP1.PARTY_TYPE) PERSON_MIDDLE_NAME
, ASO_SHIPMENT_PVT.GET_PARTY_LAST_NAME(HP1.PARTY_ID
, HP1.PARTY_TYPE) PERSON_LAST_NAME
FROM HZ_PARTIES HP1
Columns
Name |
PARTY_ID |
PARTY_NUMBER |
PARTY_TYPE |
VALIDATED_FLAG |
PARTY_NAME |
PERSON_FIRST_NAME |
PERSON_MIDDLE_NAME |
PERSON_LAST_NAME |