AP Invoice Detail Report

/*WITH SECURITY_TBL AS
(
select 
	distinct 
	HOU.organization_id
from 
	HR_ORGANIZATION_UNITS_F_TL HOU,
	fun_user_role_data_asgnmnts FURDA,
	per_roles_dn PRD,
	per_user_roles PUR,
	per_users PU
where 
	1=1
	AND FURDA.org_id 				= HOU.organization_id
	AND UPPER(FURDA.role_name) in ('XXC_ACCOUNTS_PAYABLE_ANALYST_JOB','XXC_ACCOUNTS_PAYABLE_INQUIRY_JOB','XXC_ACCOUNTS_PAYABLES_MANAGER_JOB')
	AND UPPER(FURDA.active_flag) = 'Y'
	AND UPPER(FURDA.role_name) = UPPER(PRD.role_common_name)
	AND PRD.role_id = PUR.role_id
	AND PUR.user_id = PU.user_id
	AND upper(pu.username) = upper(:xdo_user_name)
	AND pu.user_guid = FURDA.user_guid
)
*/
SELECT
SUPPLIER_NUMBER,
SUPPLIER_NAME,
ALTERNATIVE_SUPPLIER_NAME,
SUPPLIER_TAXPAYER_ID,
SUPP_TAX_REG_NUM,
SUP_TAXPAYER_ID_TYPE,
SUP_TAX_ORG_TYPE,
SUP_CLASS_TYPE,
SUPPLIER_SITE,
STATUS ,
BU_NAME,
ADDRESS1,
ADDRESS2,
ADDRESS3,
ADDRESS4,
CITY,
STATE,
PROVINCE,
POSTAL_CODE,
COUNTRY,
SUPPLIER_TERMS,
SUPP_PAYMENT_GROUP,
PAYMENT_METHOD,
SUPPLIER_EMAIL_REMIT,
INVOICE_TYPE,
INVOICE_PO,
	--PHA.SEGMENT1 INVOICE_PO,
INVOICE_DATE,
INVOICE_NUM,
INVOICE_DUE_DATE,
INVOICE_CURRENCY,
HEADER_DESC,
DISTRIBUTION_LINE_NUMBER,
DIST_LINE_TYPE,
ACCOUNTING_DATE,
DIST_LINE_ACC,
DIST_LINE_DESC,
SUM(NVL(DIST_LINE_AMOUNT,0)) DIST_LINE_AMOUNT,
TAX,
PAYMENT_NUM,
SUM(NVL(PAYMENT_AMOUNT,0)) PAYMENT_AMOUNT,
PAYMENT_DATE,
PROJECT_NUMBER,
PROJECT_NAME,
PROJECT_TYPE,
PROJECT_CLASS_CODE,
TASK_NAME,
TASK_NUMBER,
EXPENDITURE_ITEM_DATE,
EXP_BU_NAME,
EXPENDITURE_TYPE_NAME,
LINE_NUMBER
from
(	
SELECT
	PSV.segment1 SUPPLIER_NUMBER,
	PSV.VENDOR_NAME SUPPLIER_NAME,
	HAPN.PARTY_NAME ALTERNATIVE_SUPPLIER_NAME,
	PSP.INCOME_TAX_ID SUPPLIER_TAXPAYER_ID,
	ZPTP.REP_REGISTRATION_NUMBER SUPP_TAX_REG_NUM,
	AITT.DESCRIPTION SUP_TAXPAYER_ID_TYPE,
	PSV.ORGANIZATION_TYPE_LOOKUP_CODE SUP_TAX_ORG_TYPE,
	PSV.VENDOR_TYPE_LOOKUP_CODE SUP_CLASS_TYPE,
	PSSAM.VENDOR_SITE_CODE SUPPLIER_SITE,
	HPS.STATUS ,
	HOUFT.NAME BU_NAME,
	HL.ADDRESS1,
	HL.ADDRESS2,
	HL.ADDRESS3,
	HL.ADDRESS4,
	HL.CITY,
	HL.STATE,
	HL.PROVINCE,
	HL.POSTAL_CODE,
	HL.COUNTRY,
	ATV.NAME SUPPLIER_TERMS,
	PSSAM.PAY_GROUP_LOOKUP_CODE SUPP_PAYMENT_GROUP,
	IPMV.PAYMENT_METHOD_NAME PAYMENT_METHOD,
	IEPA.REMIT_ADVICE_EMAIL	SUPPLIER_EMAIL_REMIT,
	AIA.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE,
	AILA.ATTRIBUTE2 INVOICE_PO,
	--PHA.SEGMENT1 INVOICE_PO,
	AIA.INVOICE_DATE,
	AIA.INVOICE_NUM,
	APSA.DUE_DATE INVOICE_DUE_DATE,
	AIA.INVOICE_CURRENCY_CODE INVOICE_CURRENCY,
	AIA.DESCRIPTION HEADER_DESC,
	AILA.line_number DISTRIBUTION_LINE_NUMBER,
	AIDA.LINE_TYPE_LOOKUP_CODE DIST_LINE_TYPE,
	AIA.GL_DATE ACCOUNTING_DATE,
	GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6||'.'||GCC.SEGMENT7||'.'||GCC.SEGMENT8||'.'||GCC.SEGMENT9 DIST_LINE_ACC,
	AILA.DESCRIPTION DIST_LINE_DESC,
	AIDA.AMOUNT DIST_LINE_AMOUNT,
	AILA.TAX,
	/*AIPA.PAYMENT_NUM,
	AIPA.AMOUNT PAYMENT_AMOUNT,
	AIPA.ACCOUNTING_DATE PAYMENT_DATE,*/
	AC.CHECK_NUMBER PAYMENT_NUM,
	AC.AMOUNT PAYMENT_AMOUNT,
	AC.CHECK_DATE PAYMENT_DATE,
	PPAV.SEGMENT1 PROJECT_NUMBER,
	PPAV.NAME PROJECT_NAME,
	PPTV.DESCRIPTION PROJECT_TYPE,
	(SELECT DISTINCT  PCCV.class_code 
		 FROM 	pjf_class_categories_vl PCCB,
				pjf_class_codes_vl PCCV,
				pjf_project_classes_v PPC,
				pjf_projects_all_vl PPAV1
		 WHERE 
				PPAV.project_id = PPAV1.project_id
			AND PPAV1.project_id = PPC.project_id
			AND PPC.class_category_id=PCCB.class_category_id
			AND PCCB.class_category_id=PCCV.class_category_id
			AND PPC.class_code_id= PCCV.class_code_id
			AND UPPER(PCCB.class_category) IN ('PROJECT TYPE CLASS')
		)  PROJECT_CLASS_CODE,
	PPEV.NAME TASK_NAME,
	PPEV.ELEMENT_NUMBER TASK_NUMBER,
	AILA.PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE,
	PHOUFT.NAME EXP_BU_NAME,
	PETV.EXPENDITURE_TYPE_NAME,
	AILA.LINE_NUMBER,
	AIDA.DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE
FROM
	POZ_SUPPLIERS_V PSV, 
	HZ_ADDTNL_PARTY_NAMES HAPN,
	POZ_SUPPLIERS_PII PSP,
	HZ_PARTIES HP,
	ZX_PARTY_TAX_PROFILE ZPTP,
	AP_INCOME_TAX_TYPES AITT,
	POZ_SUPPLIER_SITES_ALL_M PSSAM,
	HZ_PARTY_SITES HPS,
	HR_ORGANIZATION_UNITS_F_TL HOUFT,
	HZ_LOCATIONS HL,
	AP_TERMS_V ATV,
	AP_INVOICES_ALL AIA,
	AP_CHECKS_ALL AC,
	IBY_PAYMENT_METHODS_VL IPMV,
	--PO_HEADERS_ALL PHA,
	AP_PAYMENT_SCHEDULES_ALL APSA,
	AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
	AP_INVOICE_LINES_ALL AILA,
	GL_CODE_COMBINATIONS GCC,
	AP_INVOICE_PAYMENTS_ALL AIPA,
	PJF_PROJECTS_ALL_VL PPAV,
	PJF_PROJECT_TYPES_VL PPTV,
	--PJF_CLASS_CODES_VL PCCV,
	--PJF_PROJECT_CLASSES PPC,
	PJF_PROJ_ELEMENTS_VL PPEV,
	HR_ORGANIZATION_UNITS_F_TL PHOUFT,
	PJF_EXP_TYPES_VL PETV,
	--SECURITY_TBL ST,
	--POZ_SUPP_SITES_CONTACTS_V PSSCV,
	IBY_EXTERNAL_PAYEES_ALL IEPA
	--PJC_COST_DIST_LINES_ALL PCDLA  --temporarly not using 
WHERE
	1=1
	AND PSV.party_id							= HAPN.party_id(+)
	AND PSV.vendor_id							= PSP.vendor_id(+)
	AND PSV.party_id 							= HP.party_id
	AND HP.party_id								= HAPN.party_id(+)
	AND HP.IDEN_ADDR_PARTY_SITE_ID				= ZPTP.PARTY_ID(+)
	AND PSV.TYPE_1099							= AITT.INCOME_TAX_TYPE(+)
	AND PSV.VENDOR_ID							= PSSAM.VENDOR_ID
	AND SYSDATE 								BETWEEN PSSAM.EFFECTIVE_START_DATE AND PSSAM.EFFECTIVE_END_DATE
	AND HP.PARTY_ID								= HPS.PARTY_ID
	--AND HOUFT.ORGANIZATION_ID					= ST.organization_id
	AND PSSAM.INACTIVE_DATE 					IS NULL
	AND PSSAM.PARTY_SITE_ID						= HPS.PARTY_SITE_ID
	AND HPS.LOCATION_ID							= HL.LOCATION_ID
	AND PSSAM.TERMS_ID							= ATV.TERM_ID(+)
	AND PSV.VENDOR_ID							= AIA.VENDOR_ID
	AND PSSAM.VENDOR_SITE_ID					= AIA.VENDOR_SITE_ID
	AND AIA.ORG_ID								= HOUFT.ORGANIZATION_ID
	AND SYSDATE 								BETWEEN HOUFT.EFFECTIVE_START_DATE AND HOUFT.EFFECTIVE_END_DATE
	AND HOUFT.LANGUAGE							= USERENV('LANG')
	AND APSA.PAYMENT_METHOD_CODE					= IPMV.PAYMENT_METHOD_CODE
	--AND AIA.PO_HEADER_ID						= PHA.PO_HEADER_ID(+)
	AND AIA.INVOICE_ID							= APSA.INVOICE_ID
	AND AIA.invoice_id                 			= AILA.invoice_id
    AND AIA.invoice_id                 			= AIDA.invoice_id
    AND AILA.line_number               			= AIDA.invoice_line_number
	AND AIDA.DIST_CODE_COMBINATION_ID			= GCC.CODE_COMBINATION_ID
	AND AIA.INVOICE_ID							= AIPA.INVOICE_ID(+)
	AND AIPA.CHECK_ID             				= AC.CHECK_ID(+)
	AND AC.VOID_DATE(+) IS NULL 
	AND AILA.PJC_PROJECT_ID						= PPAV.PROJECT_ID(+)
	AND AILA.PJC_TASK_ID						= PPEV.PROJ_ELEMENT_ID(+)
	AND PPAV.PROJECT_TYPE_ID					= PPTV.PROJECT_TYPE_ID(+)
	--AND PPAV.PROJECT_ID 						= PPC.PROJECT_ID(+)
	--AND PPC.CLASS_CODE_ID 					= PCCV.CLASS_CODE_ID(+)
	--AND PPAV.project_id                  		= PCDLA.project_id(+)
	--AND PCDLA.task_id             			= PPEV.PROJ_ELEMENT_ID(+)
	AND PPAV.PROJECT_ID 						= PPEV.PROJECT_ID(+)	
	AND AILA.PJC_ORGANIZATION_ID				= PHOUFT.ORGANIZATION_ID(+)
	--AND PSSAM.VENDOR_SITE_ID 					= PSSCV.VENDOR_SITE_ID(+)
	AND PSSAM.VENDOR_SITE_ID 					= IEPA.SUPPLIER_SITE_ID(+)
	AND SYSDATE 								BETWEEN PHOUFT.EFFECTIVE_START_DATE(+) AND PHOUFT.EFFECTIVE_END_DATE(+)
	AND USERENV('LANG')							= PHOUFT.LANGUAGE(+)
	AND AILA.PJC_EXPENDITURE_TYPE_ID			= PETV.EXPENDITURE_TYPE_ID(+)
	AND (PSV.VENDOR_NAME 						IN (:P_SUPPLIER_NAME) OR LEAST (:P_SUPPLIER_NAME) IS NULL)
	AND (AIA.INVOICE_TYPE_LOOKUP_CODE 			IN (:P_INVOICE_TYPE) OR LEAST (:P_INVOICE_TYPE) IS NULL)
	--AND AIA.GL_DATE							BETWEEN trunc(:P_GL_DATE_FROM) AND trunc(:P_GL_DATE_TO)
	AND trunc(AIA.GL_DATE) 						BETWEEN trunc(:P_GL_DATE_FROM) AND trunc(:P_GL_DATE_TO)
	AND (HOUFT.NAME								IN (:P_BU) OR LEAST (:P_BU) IS NULL)
	AND CAST(GCC.SEGMENT4 AS NUMERIC)		    BETWEEN CAST(:P_ACCOUNT_FROM AS NUMERIC) AND CAST(:P_ACCOUNT_TO AS NUMERIC)
	AND AIA.APPROVAL_STATUS						='APPROVED'
	AND ap_invoices_pkg.get_posting_status(aia.invoice_id)='Y'
	

UNION

SELECT
	(SELECT PAP.person_number FROM per_all_people_f PAP
								WHERE TO_CHAR(PAP.person_id)=HP.ORIG_SYSTEM_REFERENCE
								AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE AND PAP.EFFECTIVE_END_DATE) SUPPLIER_NUMBER,
	HP.PARTY_NAME SUPPLIER_NAME,
	HAPN.PARTY_NAME ALTERNATIVE_SUPPLIER_NAME,
	NULL SUPPLIER_TAXPAYER_ID,
	NULL SUPP_TAX_REG_NUM,
	NULL SUP_TAXPAYER_ID_TYPE,
	NULL SUP_TAX_ORG_TYPE,
	NULL SUP_CLASS_TYPE,
	NULL SUPPLIER_SITE,
	NULL STATUS ,
	HOUFT.NAME BU_NAME,
	NULL ADDRESS1,
	NULL ADDRESS2,
	NULL ADDRESS3,
	NULL ADDRESS4,
	NULL CITY,
	NULL STATE,
	NULL PROVINCE,
	NULL POSTAL_CODE,
	NULL COUNTRY,
	NULL SUPPLIER_TERMS,
	NULL SUPP_PAYMENT_GROUP,
	IPMV.PAYMENT_METHOD_NAME PAYMENT_METHOD,
	NULL SUPPLIER_EMAIL_REMIT,
	AIA.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE,
	AILA.ATTRIBUTE2 INVOICE_PO,
	--PHA.SEGMENT1 INVOICE_PO,
	AIA.INVOICE_DATE,
	AIA.INVOICE_NUM,
	APSA.DUE_DATE INVOICE_DUE_DATE,
	AIA.INVOICE_CURRENCY_CODE INVOICE_CURRENCY,
	AIA.DESCRIPTION HEADER_DESC,
	AILA.line_number DISTRIBUTION_LINE_NUMBER,
	AIDA.LINE_TYPE_LOOKUP_CODE DIST_LINE_TYPE,
	AIA.GL_DATE ACCOUNTING_DATE,
	GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6||'.'||GCC.SEGMENT7||'.'||GCC.SEGMENT8||'.'||GCC.SEGMENT9 DIST_LINE_ACC,
	AILA.DESCRIPTION DIST_LINE_DESC,
	AIDA.AMOUNT DIST_LINE_AMOUNT,
	AILA.TAX,
	/*AIPA.PAYMENT_NUM,
	AIPA.AMOUNT PAYMENT_AMOUNT,
	AIPA.ACCOUNTING_DATE PAYMENT_DATE,*/
	AC.CHECK_NUMBER PAYMENT_NUM,
	AC.AMOUNT PAYMENT_AMOUNT,
	AC.CHECK_DATE PAYMENT_DATE,
	PPAV.SEGMENT1 PROJECT_NUMBER,
	PPAV.NAME PROJECT_NAME,
	PPTV.DESCRIPTION PROJECT_TYPE,
	(SELECT DISTINCT  PCCV.class_code 
		 FROM 	pjf_class_categories_vl PCCB,
				pjf_class_codes_vl PCCV,
				pjf_project_classes_v PPC,
				pjf_projects_all_vl PPAV1
		 WHERE 
				PPAV.project_id = PPAV1.project_id
			AND PPAV1.project_id = PPC.project_id
			AND PPC.class_category_id=PCCB.class_category_id
			AND PCCB.class_category_id=PCCV.class_category_id
			AND PPC.class_code_id= PCCV.class_code_id
			AND UPPER(PCCB.class_category) IN ('PROJECT TYPE CLASS')
		) PROJECT_CLASS_CODE,
	PPEV.NAME TASK_NAME,
	PPEV.ELEMENT_NUMBER TASK_NUMBER,
	AILA.PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE,
	PHOUFT.NAME EXP_BU_NAME,
	PETV.EXPENDITURE_TYPE_NAME,
	AILA.LINE_NUMBER,
	AIDA.DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE
FROM
	HZ_ADDTNL_PARTY_NAMES HAPN,
	HZ_PARTIES HP,
	ZX_PARTY_TAX_PROFILE ZPTP,
	HZ_PARTY_SITES HPS,
	HR_ORGANIZATION_UNITS_F_TL HOUFT,
	AP_INVOICES_ALL AIA,
	AP_CHECKS_ALL AC,
	IBY_PAYMENT_METHODS_VL IPMV,
	--PO_HEADERS_ALL PHA,
	AP_PAYMENT_SCHEDULES_ALL APSA,
	AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
	AP_INVOICE_LINES_ALL AILA,
	GL_CODE_COMBINATIONS GCC,
	AP_INVOICE_PAYMENTS_ALL AIPA,
	PJF_PROJECTS_ALL_VL PPAV,
	PJF_PROJECT_TYPES_VL PPTV,
	--PJF_CLASS_CODES_VL PCCV,
	--PJF_PROJECT_CLASSES PPC,
	PJF_PROJ_ELEMENTS_VL PPEV,
	HR_ORGANIZATION_UNITS_F_TL PHOUFT,
	PJF_EXP_TYPES_VL PETV
	--SECURITY_TBL ST,
	--POZ_SUPP_SITES_CONTACTS_V PSSCV,
	--PJC_COST_DIST_LINES_ALL PCDLA  --temporarly not using 
WHERE
	1=1
	AND HP.party_id								= HAPN.party_id(+)
	AND HP.IDEN_ADDR_PARTY_SITE_ID				= ZPTP.PARTY_ID(+)
	AND HP.PARTY_ID								= HPS.PARTY_ID
	--AND HOUFT.ORGANIZATION_ID					= ST.organization_id
	--AND HPS.LOCATION_ID						= HL.LOCATION_ID
	AND HP.party_id								= AIA.PARTY_ID
	AND AIA.ORG_ID								= HOUFT.ORGANIZATION_ID
	AND SYSDATE 								BETWEEN HOUFT.EFFECTIVE_START_DATE AND HOUFT.EFFECTIVE_END_DATE
	AND HOUFT.LANGUAGE							= USERENV('LANG')
	AND APSA.PAYMENT_METHOD_CODE					= IPMV.PAYMENT_METHOD_CODE
	--AND AIA.PO_HEADER_ID						= PHA.PO_HEADER_ID(+)
	AND AIA.INVOICE_ID							= APSA.INVOICE_ID
	AND AIA.invoice_id                 			= AILA.invoice_id
    AND AIA.invoice_id                 			= AIDA.invoice_id
    AND AILA.line_number               			= AIDA.invoice_line_number
	AND AIDA.DIST_CODE_COMBINATION_ID			= GCC.CODE_COMBINATION_ID
	AND AIA.INVOICE_ID							= AIPA.INVOICE_ID(+)
	AND AIPA.CHECK_ID             				= AC.CHECK_ID(+)
	AND AC.VOID_DATE(+) IS NULL 
	AND AILA.PJC_PROJECT_ID						= PPAV.PROJECT_ID(+)
	AND AILA.PJC_TASK_ID						= PPEV.PROJ_ELEMENT_ID(+)
	AND PPAV.PROJECT_TYPE_ID					= PPTV.PROJECT_TYPE_ID(+)
	--AND PPAV.PROJECT_ID 						= PPC.PROJECT_ID(+)
	--AND PPC.CLASS_CODE_ID 						= PCCV.CLASS_CODE_ID(+)
	--AND PPAV.project_id                  		= PCDLA.project_id(+)
	--AND PCDLA.task_id             			= PPEV.PROJ_ELEMENT_ID(+)
	AND PPAV.PROJECT_ID 						= PPEV.PROJECT_ID(+)	
	AND AILA.PJC_ORGANIZATION_ID				= PHOUFT.ORGANIZATION_ID(+)
	AND SYSDATE 								BETWEEN PHOUFT.EFFECTIVE_START_DATE(+) AND PHOUFT.EFFECTIVE_END_DATE(+)
	AND USERENV('LANG')							= PHOUFT.LANGUAGE(+)
	AND AILA.PJC_EXPENDITURE_TYPE_ID			= PETV.EXPENDITURE_TYPE_ID(+)
	AND (HP.PARTY_NAME 						IN (:P_SUPPLIER_NAME) OR LEAST (:P_SUPPLIER_NAME) IS NULL)
	AND (AIA.INVOICE_TYPE_LOOKUP_CODE 			IN (:P_INVOICE_TYPE) OR LEAST (:P_INVOICE_TYPE) IS NULL)
	--AND AIA.GL_DATE							BETWEEN trunc(:P_GL_DATE_FROM) AND trunc(:P_GL_DATE_TO)
	AND trunc(AIA.GL_DATE) 						BETWEEN trunc(:P_GL_DATE_FROM) AND trunc(:P_GL_DATE_TO)
	AND (HOUFT.NAME								IN (:P_BU) OR LEAST (:P_BU) IS NULL)
	AND CAST(GCC.SEGMENT4 AS NUMERIC)		    BETWEEN CAST(:P_ACCOUNT_FROM AS NUMERIC) AND CAST(:P_ACCOUNT_TO AS NUMERIC)
	
	AND AIA.APPROVAL_STATUS						='APPROVED'
	AND ap_invoices_pkg.get_posting_status(aia.invoice_id)='Y'
	AND NOT EXISTS (
						SELECT AI.INVOICE_ID
						FROM AP_INVOICES_ALL AI
							,	POZ_SUPPLIERS_V PS
						WHERE AI.vendor_id=PS.vendor_id
							and AI.INVOICE_ID=AIA.INVOICE_ID
					)
)
GROUP BY 
SUPPLIER_NUMBER,
SUPPLIER_NAME,
ALTERNATIVE_SUPPLIER_NAME,
SUPPLIER_TAXPAYER_ID,
SUPP_TAX_REG_NUM,
SUP_TAXPAYER_ID_TYPE,
SUP_TAX_ORG_TYPE,
SUP_CLASS_TYPE,
SUPPLIER_SITE,
STATUS ,
BU_NAME,
ADDRESS1,
ADDRESS2,
ADDRESS3,
ADDRESS4,
CITY,
STATE,
PROVINCE,
POSTAL_CODE,
COUNTRY,
SUPPLIER_TERMS,
SUPP_PAYMENT_GROUP,
PAYMENT_METHOD,
SUPPLIER_EMAIL_REMIT,
INVOICE_TYPE,
INVOICE_PO,
	--PHA.SEGMENT1 INVOICE_PO,
INVOICE_DATE,
INVOICE_NUM,
INVOICE_DUE_DATE,
INVOICE_CURRENCY,
HEADER_DESC,
DISTRIBUTION_LINE_NUMBER,
DIST_LINE_TYPE,
ACCOUNTING_DATE,
DIST_LINE_ACC,
DIST_LINE_DESC,
TAX,
PAYMENT_NUM,
PAYMENT_DATE,
PROJECT_NUMBER,
PROJECT_NAME,
PROJECT_TYPE,
PROJECT_CLASS_CODE,
TASK_NAME,
TASK_NUMBER,
EXPENDITURE_ITEM_DATE,
EXP_BU_NAME,
EXPENDITURE_TYPE_NAME,
LINE_NUMBER		
ORDER BY
INVOICE_NUM,
DISTRIBUTION_LINE_NUMBER