Product: | AS - Sales Foundation |
---|---|
Description: | Currently not in use |
Implementation/DBA Data: | Not implemented in this database |
SELECT PURCHASES.SEQUENCE_NUM
, PURCHASES.LAST_UPDATE_DATE
, PURCHASES.LAST_UPDATED_BY
, PURCHASES.CREATION_DATE
, PURCHASES.CREATED_BY
, PURCHASES.LAST_UPDATE_LOGIN
, PURCHASES.INTEREST_TYPE_ID
, PURCHASES.PRIMARY_INTEREST_CODE_ID
, PURCHASES.SECONDARY_INTEREST_CODE_ID
, PURCHASES.ITEM_ID
, PURCHASES.ORGANIZATION_ID
, INTTYPE.INTEREST_TYPE
, INTCODE1.CODE
, INTCODE2.CODE
, PURCHASES.ROWID
FROM AS_DEFAULT_PURCHASES PURCHASES
, AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_VL INTCODE1
, AS_INTEREST_CODES_VL INTCODE2
WHERE INTCODE1.INTEREST_CODE_ID(+) = PURCHASES.PRIMARY_INTEREST_CODE_ID
AND INTCODE2.INTEREST_CODE_ID (+) = PURCHASES.SECONDARY_INTEREST_CODE_ID
AND INTTYPE.INTEREST_TYPE_ID (+) = PURCHASES.INTEREST_TYPE_ID