Product: | AP - Payables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AP_EXPENSE_FEED_LINES_V |
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