[Home] [Help]
View: OKX_INV_PREPAYS_V
Product: | OKX - Contracts Integration |
Description: | Supplier invoice prepayments |
Implementation/DBA Data: |
APPS.OKX_INV_PREPAYS_V
|
View Text
SELECT IP.PREPAY_ID ID1
, IP.INVOICE_ID ID2
, IP.PREPAYMENT_AMOUNT_APPLIED PREPAYMENT_AMOUNT_APPLIED
, IP.DATE_REPORTED DATE_REPORTED
, IP.ORG_ID ORG_ID
, IP.INVOICE_ID NAME
, IP.PREPAYMENT_AMOUNT_APPLIED || ' REPORTED ON ' || IP.DATE_REPORTED DESCRIPTION
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
, 'A' STATUS
FROM AP_INVOICE_PREPAYS_ALL IP
Columns
Name |
ID1 |
ID2 |
PREPAYMENT_AMOUNT_APPLIED |
DATE_REPORTED |
ORG_ID |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |