[Home] [Help]
View: CUN_AP_PA_INVOICES_V
| Product: | CUN - Network Logistics - NATS (obsolete) |
|---|
| Description: | AP Invoices for NL tracked items to Oracle Projects |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DIST.INVOICE_ID
, DIST.DISTRIBUTION_LINE_NUMBER
, NVL(PO.PO_DISTRIBUTION_ID
, DIST.PO_DISTRIBUTION_ID) PO_DISTRIBUTION_ID
, DIST.PA_ADDITION_FLAG
, DIST.REQUEST_ID
, DIST.PROJECT_ID
, DIST.TASK_ID
FROM AP_INVOICE_DISTRIBUTIONS DIST
, PO_DISTRIBUTIONS PO
WHERE DIST.PROJECT_ID > 0
AND DIST.PO_DISTRIBUTION_ID = PO.PO_DISTRIBUTION_ID(+)
AND EXISTS (SELECT 'X' FROM CUN_TRANSACTIONS CT WHERE CT.PO_DISTRIBUTION_ID = DIST.PO_DISTRIBUTION_ID AND CT.PROJECT_ID = DIST.PROJECT_ID AND CT.TASK_ID = DIST.TASK_ID AND CT.TRANSACTION_TYPE = 'RECEIPT_INTO_PROJECT' AND CT.TRANSACTION_STATUS = 'C')
Columns
| Name |
| INVOICE_ID |
| DISTRIBUTION_LINE_NUMBER |
| PO_DISTRIBUTION_ID |
| PA_ADDITION_FLAG |
| REQUEST_ID |
| PROJECT_ID |
| TASK_ID |