VIEW: APPS.AP_EXPENSE_FEED_LINES_V

Source

View Text - Preformatted

SELECT EFL.ROWID, EFL.EMPLOYEE_ID , EFL.CARD_ID , EFL.CARD_PROGRAM_ID , IBY.CARD_NUMBER , EFL.FEED_LINE_ID , EFL.REFERENCE_NUMBER , EFL.ALT_REFERENCE_NUMBER , EFL.CUSTOMER_CODE , EFL.AMOUNT , EFL.ORIGINAL_CURRENCY_AMOUNT , EFL.ORIGINAL_CURRENCY_CODE , EFL.POSTED_CURRENCY_CODE , EFL.CURRENCY_CONVERSION_RATE , EFL.TRANSACTION_DATE , EFL.POSTED_DATE , EFL.RECORD_TYPE , EFL.CREATE_DISTRIBUTION_FLAG , EFL.MERCHANT_NAME , EFL.MERCHANT_NUMBER , EFL.CARD_CODE_VALUE , EFL.CODE_ID , EFL.INDUSTRY_CODE1 , EFL.INDUSTRY_CODE2 , EFL.ALT_MERCHANT_NUMBER , EFL.MERCHANT_ADDRESS1 , EFL.MERCHANT_ADDRESS2 , EFL.MERCHANT_ADDRESS3 , EFL.MERCHANT_ADDRESS4 , EFL.MERCHANT_CITY , EFL.MERCHANT_PROVINCE_STATE , EFL.MERCHANT_POSTAL_CODE , EFL.MERCHANT_COUNTRY , EFL.MERCHANT_PHONE , EFL.SHIP_FROM_POSTAL_CODE , EFL.SHIP_FROM_COUNTRY , EFL.SHIP_TO_POSTAL_CODE , EFL.SHIP_TO_COUNTRY , EFL.MERCHANT_TAX_ID , EFL.TAX_PAID_FLAG , EFL.TAX_AMOUNT , EFL.TAX_RATE , EFL.TAX_TYPE , EFL.ALT_MERCHANT_TAX_ID , EFL.ALT_TAX_PAID_FLAG , EFL.ALT_TAX_AMOUNT , EFL.ALT_TAX_RATE , EFL.ALT_TAX_TYPE , EFL.FREIGHT_AMOUNT , EFL.DUTY_AMOUNT , EFL.MERCHANT_BUSINESS_TYPE , EFL.MERCHANT_OWNER_TYPE , EFL.PRODUCT_CODE , EFL.ITEM_DESCRIPTION , EFL.ITEM_QUANTITY , EFL.ITEM_UOM , EFL.EXTENDED_ITEM_AMOUNT , EFL.DISCOUNT_INDICATOR , EFL.DISCOUNT_AMOUNT , EFL.EMPLOYEE_VERIFICATION_ID , EFL.DESCRIPTION , EFL.REJECT_CODE , EFL.ORG_ID , EFL.LAST_UPDATE_DATE , EFL.LAST_UPDATED_BY , EFL.LAST_UPDATE_LOGIN , EFL.CREATION_DATE , EFL.CREATED_BY , EFL.ATTRIBUTE_CATEGORY , EFL.ATTRIBUTE1 , EFL.ATTRIBUTE2 , EFL.ATTRIBUTE3 , EFL.ATTRIBUTE4 , EFL.ATTRIBUTE5 , EFL.ATTRIBUTE6 , EFL.ATTRIBUTE7 , EFL.ATTRIBUTE8 , EFL.ATTRIBUTE9 , EFL.ATTRIBUTE10 , EFL.ATTRIBUTE11 , EFL.ATTRIBUTE12 , EFL.ATTRIBUTE13 , EFL.ATTRIBUTE14 , EFL.ATTRIBUTE15 , EFL.ATTRIBUTE16 , EFL.ATTRIBUTE17 , EFL.ATTRIBUTE18 , EFL.ATTRIBUTE19 , EFL.ATTRIBUTE20 , EFL.ATTRIBUTE21 , EFL.ATTRIBUTE22 , EFL.ATTRIBUTE23 , EFL.ATTRIBUTE24 , EFL.ATTRIBUTE25 , EFL.ATTRIBUTE26 , EFL.ATTRIBUTE27 , EFL.ATTRIBUTE28 , EFL.ATTRIBUTE29 , EFL.ATTRIBUTE30 , IBY.CARD_NUMBER SET_UP_CARD_NUMBER , C.EMPLOYEE_ID CARD_EMPLOYEE_ID , C.DEPARTMENT_NAME , CP.CARD_PROGRAM_NAME , CP.CARD_TYPE_LOOKUP_CODE , CPR.PROFILE_NAME , HREMP.FULL_NAME FROM AP_EXPENSE_FEED_LINES EFL, AP_CARDS C, AP_CARD_PROGRAMS CP, AP_CARD_PROFILES CPR, HR_EMPLOYEES_CURRENT_V HREMP, IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY WHERE C.CARD_REFERENCE_ID = IBY.INSTRUMENT_ID (+) AND EFL.EMPLOYEE_ID = HREMP.EMPLOYEE_ID (+) AND EFL.CARD_PROGRAM_ID = CP.CARD_PROGRAM_ID AND C.PROFILE_ID = CPR.PROFILE_ID (+) AND C.CARD_ID=EFL.CARD_ID AND IBY.instrument_type='CREDITCARD'

View Text - HTML Formatted

SELECT EFL.ROWID
, EFL.EMPLOYEE_ID
, EFL.CARD_ID
, EFL.CARD_PROGRAM_ID
, IBY.CARD_NUMBER
, EFL.FEED_LINE_ID
, EFL.REFERENCE_NUMBER
, EFL.ALT_REFERENCE_NUMBER
, EFL.CUSTOMER_CODE
, EFL.AMOUNT
, EFL.ORIGINAL_CURRENCY_AMOUNT
, EFL.ORIGINAL_CURRENCY_CODE
, EFL.POSTED_CURRENCY_CODE
, EFL.CURRENCY_CONVERSION_RATE
, EFL.TRANSACTION_DATE
, EFL.POSTED_DATE
, EFL.RECORD_TYPE
, EFL.CREATE_DISTRIBUTION_FLAG
, EFL.MERCHANT_NAME
, EFL.MERCHANT_NUMBER
, EFL.CARD_CODE_VALUE
, EFL.CODE_ID
, EFL.INDUSTRY_CODE1
, EFL.INDUSTRY_CODE2
, EFL.ALT_MERCHANT_NUMBER
, EFL.MERCHANT_ADDRESS1
, EFL.MERCHANT_ADDRESS2
, EFL.MERCHANT_ADDRESS3
, EFL.MERCHANT_ADDRESS4
, EFL.MERCHANT_CITY
, EFL.MERCHANT_PROVINCE_STATE
, EFL.MERCHANT_POSTAL_CODE
, EFL.MERCHANT_COUNTRY
, EFL.MERCHANT_PHONE
, EFL.SHIP_FROM_POSTAL_CODE
, EFL.SHIP_FROM_COUNTRY
, EFL.SHIP_TO_POSTAL_CODE
, EFL.SHIP_TO_COUNTRY
, EFL.MERCHANT_TAX_ID
, EFL.TAX_PAID_FLAG
, EFL.TAX_AMOUNT
, EFL.TAX_RATE
, EFL.TAX_TYPE
, EFL.ALT_MERCHANT_TAX_ID
, EFL.ALT_TAX_PAID_FLAG
, EFL.ALT_TAX_AMOUNT
, EFL.ALT_TAX_RATE
, EFL.ALT_TAX_TYPE
, EFL.FREIGHT_AMOUNT
, EFL.DUTY_AMOUNT
, EFL.MERCHANT_BUSINESS_TYPE
, EFL.MERCHANT_OWNER_TYPE
, EFL.PRODUCT_CODE
, EFL.ITEM_DESCRIPTION
, EFL.ITEM_QUANTITY
, EFL.ITEM_UOM
, EFL.EXTENDED_ITEM_AMOUNT
, EFL.DISCOUNT_INDICATOR
, EFL.DISCOUNT_AMOUNT
, EFL.EMPLOYEE_VERIFICATION_ID
, EFL.DESCRIPTION
, EFL.REJECT_CODE
, EFL.ORG_ID
, EFL.LAST_UPDATE_DATE
, EFL.LAST_UPDATED_BY
, EFL.LAST_UPDATE_LOGIN
, EFL.CREATION_DATE
, EFL.CREATED_BY
, EFL.ATTRIBUTE_CATEGORY
, EFL.ATTRIBUTE1
, EFL.ATTRIBUTE2
, EFL.ATTRIBUTE3
, EFL.ATTRIBUTE4
, EFL.ATTRIBUTE5
, EFL.ATTRIBUTE6
, EFL.ATTRIBUTE7
, EFL.ATTRIBUTE8
, EFL.ATTRIBUTE9
, EFL.ATTRIBUTE10
, EFL.ATTRIBUTE11
, EFL.ATTRIBUTE12
, EFL.ATTRIBUTE13
, EFL.ATTRIBUTE14
, EFL.ATTRIBUTE15
, EFL.ATTRIBUTE16
, EFL.ATTRIBUTE17
, EFL.ATTRIBUTE18
, EFL.ATTRIBUTE19
, EFL.ATTRIBUTE20
, EFL.ATTRIBUTE21
, EFL.ATTRIBUTE22
, EFL.ATTRIBUTE23
, EFL.ATTRIBUTE24
, EFL.ATTRIBUTE25
, EFL.ATTRIBUTE26
, EFL.ATTRIBUTE27
, EFL.ATTRIBUTE28
, EFL.ATTRIBUTE29
, EFL.ATTRIBUTE30
, IBY.CARD_NUMBER SET_UP_CARD_NUMBER
, C.EMPLOYEE_ID CARD_EMPLOYEE_ID
, C.DEPARTMENT_NAME
, CP.CARD_PROGRAM_NAME
, CP.CARD_TYPE_LOOKUP_CODE
, CPR.PROFILE_NAME
, HREMP.FULL_NAME
FROM AP_EXPENSE_FEED_LINES EFL
, AP_CARDS C
, AP_CARD_PROGRAMS CP
, AP_CARD_PROFILES CPR
, HR_EMPLOYEES_CURRENT_V HREMP
, IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY
WHERE C.CARD_REFERENCE_ID = IBY.INSTRUMENT_ID (+)
AND EFL.EMPLOYEE_ID = HREMP.EMPLOYEE_ID (+)
AND EFL.CARD_PROGRAM_ID = CP.CARD_PROGRAM_ID
AND C.PROFILE_ID = CPR.PROFILE_ID (+)
AND C.CARD_ID=EFL.CARD_ID
AND IBY.INSTRUMENT_TYPE='CREDITCARD'