EBS Oracle - SQL Basic Query in Oracle Apps

here i am going to show you how to get data Information with basic query in EBS Oracle apps ,




AP_PAYMENT_HISTORY_ALL

SELECT DISTINCT TRANSACTION_TYPE FROM AP_PAYMENT_HISTORY_ALL

Transaction_Type
-----------------------------------
TRANSACTION_TYPE
PAYMENT CREATED
PAYMENT CLEARING
MANUAL PAYMENT ADJUSTED
PAYMENT ADJUSTED
PAYMENT CLEARING ADJUSTED
REFUND RECORDED
PAYMENT UNCLEARING
PAYMENT CANCELLED