FND Design Data [Home] [Help]

Table: AS_COLLATERAL_REQ_ALL

Product: AS - Sales Foundation
Description: Contains collateral requests
Implementation/DBA Data: TableOSM.AS_COLLATERAL_REQ_ALL
Primary Key: AS_COLLATERAL_REQUESTS_PK
  1. ColumnCOLLATERAL_REQUEST_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_COLLATERAL_REQ_ALL FK Joins to TableAS_PROMOTIONS_ALL AS_COLLATERAL_REQ_ALL.LIST_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableAS_PROMOTIONS_ALL AS_COLLATERAL_REQ_ALL.MAIL_BLITZ_ID
AS_COLLATERAL_REQ_ALL FK Joins to Table% AS_COLLATERAL_REQ_ALL.CONTACT_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableRA_ADDRESSES_ALL AS_COLLATERAL_REQ_ALL.ADDRESS_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableAS_PROMOTIONS_ALL AS_COLLATERAL_REQ_ALL.LETTER_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableRA_CUSTOMERS AS_COLLATERAL_REQ_ALL.CUSTOMER_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableAS_LIST_ENTRIES AS_COLLATERAL_REQ_ALL.LIST_ENTRY_ID
AS_COLLATERAL_REQ_ALL FK Joins to TableSO_HEADERS_ALL AS_COLLATERAL_REQ_ALL.ORDER_NUMBER
TableAS_COLLATERAL_REQ_ITEMS FK Joins to AS_COLLATERAL_REQ_ALL AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID