[Home] [Help]
View: FII_AP_OPEN_PAYMT_DTL_SUM_V
| Product: | FII - Financial Intelligence |
| Description: | FII_AP_OPEN_PAYMT_DTL_SUM_V is the view to support Payables Open Payments Detail Drill Downs Portlet |
| Implementation/DBA Data: |
APPS.FII_AP_OPEN_PAYMT_DTL_SUM_V
|
View Text
SELECT OPERATING_UNIT_PK_KEY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, INVOICE_PK_KEY INVOICE_PK_KEY
, INVOICE_NUM INVOICE_NUMBER
, INVOICE_AMOUNT INVOICE_AMOUNT
, SCH_PAYMENT_ID PAYMENT_ID
, OPEN_PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_DUE_DATE PAYMENT_DUE_DATE
FROM FII_AP_TRANS_BACKLOG_SUMMARY
Columns
| Name |
| OPERATING_UNIT_PK_KEY |
| OPERATING_UNIT_NAME |
| TRADING_PARTNER_PK_KEY |
| TRADING_PARTNER_NAME |
| INVOICE_PK_KEY |
| INVOICE_NUMBER |
| INVOICE_AMOUNT |
| PAYMENT_ID |
| PAYMENT_AMOUNT |
| PAYMENT_DUE_DATE |