View: AS_COLLATERAL_REQUESTS_V

View Text

SELECT CR.ROWID
, CR.COLLATERAL_REQUEST_ID
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATED_BY
, CR.CREATION_DATE
, CR.CREATED_BY
, CR.LAST_UPDATE_LOGIN
, CR.REQUEST_ID
, CR.PROGRAM_APPLICATION_ID
, CR.PROGRAM_ID
, CR.PROGRAM_UPDATE_DATE
, CR.STATUS
, CR.PARTIAL_SHIP_FLAG
, CR.SCHEDULED_DATE
, CR.LIST_ID
, CR.LIST_ENTRY_ID
, CR.LETTER_ID
, CR.CUSTOMER_ID
, CR.CONTACT_ID
, CR.PERSON_ID
, CR.ADDRESS_ID
, CR.FAX_AREA_CODE
, CR.FAX_NUMBER
, CR.PRINTER_NAME
, CR.COMPLETION_DATE
, CR.SHIPMENT_INSTRUCTIONS
, CR.SHIPMENT_METHOD
, CR.ORGANIZATION_ID
, CR.MERGE_FILE_NAME
, CR.ORDER_NUMBER
, CR.DATE_FORMAT_MASK
, CR.TIME_FORMAT_MASK
, CR.DELIVERY_METHOD
, CR.ATTRIBUTE_CATEGORY
, CR.ATTRIBUTE1
, CR.ATTRIBUTE2
, CR.ATTRIBUTE3
, CR.ATTRIBUTE4
, CR.ATTRIBUTE5
, CR.ATTRIBUTE6
, CR.ATTRIBUTE7
, CR.ATTRIBUTE8
, CR.ATTRIBUTE9
, CR.ATTRIBUTE10
, CR.ATTRIBUTE11
, CR.ATTRIBUTE12
, CR.ATTRIBUTE13
, CR.ATTRIBUTE14
, CR.ATTRIBUTE15
, ASLKP1.MEANING
, P.CODE
, P.NAME
, P.EXTERNAL_FILE_NAME
, WP.PATH
, WP.STARTUP_COMMAND
, WP.LETTER_LOCATION_PATH
, WP.MERGE_FILE_LOCATION_PATH
, CUST.CUSTOMER_NAME
, CONT.FIRST_NAME
, CONT.LAST_NAME
, CONT.CONTACT_NUMBER
, CONT.TITLE
, ASLKP2.MEANING
, ADDR.ADDRESS_ID
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.POSTAL_CODE
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, TERR.TERRITORY_SHORT_NAME
, PADDR.ADDRESS_ID
, PADDR.ADDRESS1
, PADDR.ADDRESS2
, PADDR.ADDRESS3
, PADDR.ADDRESS4
, PADDR.CITY
, PADDR.POSTAL_CODE
, PADDR.STATE
, PADDR.PROVINCE
, PADDR.COUNTY
, PTERR.TERRITORY_CODE
, PTERR.TERRITORY_SHORT_NAME
FROM AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, FND_TERRITORIES_TL TERR
, FND_TERRITORIES_TL PTERR
, AS_WORD_PROCESSORS WP
, AS_PROMOTIONS P
, RA_ADDRESSES PADDR
, RA_CUSTOMERS CUST
, RA_ADDRESSES ADDR
, RA_CONTACTS CONT
, AS_COLLATERAL_REQ CR
WHERE CR.LETTER_ID = P.PROMOTION_ID(+)
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND CR.STATUS = ASLKP1.LOOKUP_CODE
AND ASLKP1.LOOKUP_TYPE = 'COLLATERAL_REQUEST_STATUS'
AND CR.SHIPMENT_METHOD = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'FREIGHT_CARRIER'
AND P.WORD_PROCESSOR_ID = WP.WORD_PROCESSOR_ID(+)
AND CONT.MAILING_ADDRESS_ID = PADDR.ADDRESS_ID(+)
AND PADDR.COUNTRY = PTERR.TERRITORY_CODE(+)
AND PTERR.LANGUAGE(+) = USERENV('LANG')
AND CONT.ADDRESS_ID = ADDR.ADDRESS_ID(+)
AND CR.CONTACT_ID = CONT.CONTACT_ID
AND CR.CUSTOMER_ID = CUST.CUSTOMER_ID

Columns