50: JAI_CMN_INVENTORY_ORGS JHOU,
51: AP_INVOICES_ALL API1,
52: AP_INVOICES_ALL API2,
53: AP_INVOICE_PAYMENTS_ALL APIP,
54: PO_VENDORS POV1,
55: PO_VENDORS POV2,
56: PO_VENDORS POV3,
57: PO_VENDOR_SITES_ALL POVS,
58: AP_INVOICE_LINES_ALL APLA
51: AP_INVOICES_ALL API1,
52: AP_INVOICES_ALL API2,
53: AP_INVOICE_PAYMENTS_ALL APIP,
54: PO_VENDORS POV1,
55: PO_VENDORS POV2,
56: PO_VENDORS POV3,
57: PO_VENDOR_SITES_ALL POVS,
58: AP_INVOICE_LINES_ALL APLA
59: WHERE DECODE(AFRM.ORG_ID
52: AP_INVOICES_ALL API2,
53: AP_INVOICE_PAYMENTS_ALL APIP,
54: PO_VENDORS POV1,
55: PO_VENDORS POV2,
56: PO_VENDORS POV3,
57: PO_VENDOR_SITES_ALL POVS,
58: AP_INVOICE_LINES_ALL APLA
59: WHERE DECODE(AFRM.ORG_ID
60: ,NULL
146: DISTINCT
147: ( NVL(PO.VENDOR_NAME
148: ,'NULL') )
149: FROM
150: PO_VENDORS PO,
151: JAI_AP_TDS_F16_HDRS_ALL AFRM,
152: JAI_AP_TDS_VENDOR_HDRS TDS
153: WHERE PO.VENDOR_ID = AFRM.TAX_AUTHORITY_ID
154: AND TDS.TAX_ID = AFRM.TDS_TAX_ID