View: ASO_PVT_SHIPMENTS_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_PVT_SHIPMENTS_V

View Text

SELECT SHIP.SHIPMENT_ID
, SHIP.CREATION_DATE
, SHIP.CREATED_BY
, SHIP.LAST_UPDATE_DATE
, SHIP.LAST_UPDATED_BY
, SHIP.LAST_UPDATE_LOGIN
, SHIP.REQUEST_ID
, SHIP.PROGRAM_APPLICATION_ID
, SHIP.PROGRAM_ID
, SHIP.PROGRAM_UPDATE_DATE
, SHIP.QUOTE_HEADER_ID
, SHIP.QUOTE_LINE_ID
, SHIP.PROMISE_DATE
, SHIP.REQUEST_DATE
, SHIP.SCHEDULE_SHIP_DATE
, SHIP.SHIP_TO_PARTY_ID
, I_PARTY_REL.PARTY_ID
, I_PARTY_REL_PARTY.PARTY_NAME
, NULL
, NULL
, NULL
, SHIP.SHIP_TO_PARTY_SITE_ID
, I_SHIP_ADDR.ADDRESS1 SHIP_TO_ADDRESS1
, I_SHIP_ADDR.ADDRESS2 SHIP_TO_ADDRESS2
, I_SHIP_ADDR.ADDRESS3 SHIP_TO_ADDRESS3
, I_SHIP_ADDR.ADDRESS4 SHIP_TO_ADDRESS4
, I_SHIP_ADDR.COUNTRY SHIP_TO_COUNTRY_CODE
, FND_TERRITORIES_VL.TERRITORY_SHORT_NAME SHIP_TO_COUNTRY
, I_SHIP_ADDR.CITY SHIP_TO_CITY
, I_SHIP_ADDR.POSTAL_CODE SHIP_TO_POSTAL_CODE
, I_SHIP_ADDR.STATE SHIP_TO_STATE
, I_SHIP_ADDR.PROVINCE SHIP_TO_PROVINCE
, I_SHIP_ADDR.COUNTY SHIP_TO_COUNTY
, SHIP.SHIP_PARTIAL_FLAG
, SHIP.SHIP_SET_ID
, SHIP.SHIP_METHOD_CODE
, SHIP.FREIGHT_TERMS_CODE
, SHIP.FREIGHT_CARRIER_CODE
, SHIP.FOB_CODE
, SHIP.SHIPPING_INSTRUCTIONS
, SHIP.PACKING_INSTRUCTIONS
, SHIP.QUANTITY
, SHIP.RESERVED_QUANTITY
, SHIP.RESERVATION_ID
, SHIP.ORDER_LINE_ID
, SHIP.SHIPMENT_PRIORITY_CODE
, SHIP.ATTRIBUTE_CATEGORY
, SHIP.ATTRIBUTE1
, SHIP.ATTRIBUTE2
, SHIP.ATTRIBUTE3
, SHIP.ATTRIBUTE4
, SHIP.ATTRIBUTE5
, SHIP.ATTRIBUTE6
, SHIP.ATTRIBUTE7
, SHIP.ATTRIBUTE8
, SHIP.ATTRIBUTE9
, SHIP.ATTRIBUTE10
, SHIP.ATTRIBUTE11
, SHIP.ATTRIBUTE12
, SHIP.ATTRIBUTE13
, SHIP.ATTRIBUTE14
, SHIP.ATTRIBUTE15
, SHIP.SHIP_QUOTE_PRICE
, DECODE(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, NULL
, TO_NUMBER(NULL)
, I_CUST.CUST_ACCOUNT_ID)
, DECODE(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, NULL
, TO_NUMBER(NULL)
, I_CUST_PARTIES.PARTY_ID)
, DECODE(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST_PARTIES.PARTY_NAME) CUSTOMER_NAME
, DECODE(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST_PARTIES.PARTY_TYPE) CUSTOMER_TYPE
, DECODE(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST.ACCOUNT_NUMBER) CUSTOMER_ACCOUNT_NUMBER
FROM ASO_SHIPMENTS SHIP
, HZ_PARTY_SITES I_SHIP_SITE
, HZ_LOCATIONS I_SHIP_ADDR
, HZ_PARTIES I_SHIP_PARTIES
, HZ_RELATIONSHIPS I_PARTY_REL
, HZ_PARTIES I_PARTY_REL_PARTY
, HZ_CUST_ACCOUNTS I_CUST
, HZ_PARTIES I_CUST_PARTIES
, FND_TERRITORIES_VL
, ASO_QUOTE_HEADERS_ALL ASO_QUOTE
WHERE SHIP.SHIP_TO_PARTY_SITE_ID = I_SHIP_SITE.PARTY_SITE_ID(+)
AND I_SHIP_SITE.LOCATION_ID = I_SHIP_ADDR.LOCATION_ID(+)
AND I_SHIP_ADDR.COUNTRY = FND_TERRITORIES_VL.TERRITORY_CODE(+)
AND SHIP.SHIP_TO_PARTY_ID = I_SHIP_PARTIES.PARTY_ID(+)
AND I_SHIP_PARTIES.PARTY_ID = I_PARTY_REL.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_ID = I_PARTY_REL_PARTY.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_TYPE(+) = 'PERSON'
AND I_PARTY_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND NVL(I_PARTY_REL.OBJECT_ID
, I_CUST.PARTY_ID) = I_CUST.PARTY_ID
AND SHIP.QUOTE_HEADER_ID = ASO_QUOTE.QUOTE_HEADER_ID
AND NVL(SHIP.SHIP_TO_CUST_ACCOUNT_ID
, ASO_QUOTE.CUST_ACCOUNT_ID) = I_CUST.CUST_ACCOUNT_ID
AND I_CUST.PARTY_ID = I_CUST_PARTIES.PARTY_ID

Columns