ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2A83869E053B46B63588994 SELECT DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',AG.AGREEMENT_NUM,OK.CONTRACT_NUMBER) CONTRACT_NUMBER, DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',CINV.INVOICE_DATE,OKE_HEADER.START_DATE) INVOICE_DATE, CINV.INVOICE_DATE DVP, INV.BILL_THROUGH_DATE BILL_DATE, NVL(CINV.RA_INVOICE_NUMBER,' ') RA_INVOICE_NUMBER FROM PA_DRAFT_INVOICE_ACRN ACRN, PA_DRAFT_CONSOLIDATED_INV_ALL CINV, OKE_PA_BILLING_PARAMS_V OK, PA_DRAFT_INVOICES_ALL INV, PA_AGREEMENTS_ALL AG, OKE_K_HEADERS_FULL_V OKE_HEADER WHERE ACRN.DRAFT_INVOICE_NUM = INV.DRAFT_INVOICE_NUM AND ACRN.PROJECT_ID = INV.PROJECT_ID AND CINV.DRAFT_INVOICE_NUM=INV.CONSOLIDATED_INV_NUM AND CINV.BILL_GROUP_ID=INV.BILL_GROUP_ID AND ACRN.PROJECT_ID = OK.PROJECT_ID(+) AND NVL(ACRN.TASK_ID,0) = NVL(OK.TASK_ID,0) AND CINV.RA_INVOICE_NUMBER = :ARINVNUM AND AG.AGREEMENT_ID=INV.AGREEMENT_ID AND ROWNUM=1 GROUP BY OK.CONTRACT_NUMBER, CINV.INVOICE_DATE, CINV.RA_INVOICE_NUMBER, AG.AGREEMENT_NUM, INV.BILL_THROUGH_DATE, OKE_HEADER.START_DATE UNION SELECT DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',AG.AGREEMENT_NUM,OK.CONTRACT_NUMBER) CONTRACT_NUMBER, DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',CINV.INVOICE_DATE,OKE_HEADER.START_DATE) INVOICE_DATE, CINV.INVOICE_DATE DVP, INV.BILL_THROUGH_DATE BILL_DATE, NVL(CINV.RA_INVOICE_NUMBER,' ') RA_INVOICE_NUMBER FROM PA_DRAFT_INVOICE_ACRN ACRN, PA_DRAFT_CONSOLIDATED_INV_ALL CINV, OKE_PA_BILLING_PARAMS_V OK, PA_DRAFT_INVOICES_ALL INV, PA_AGREEMENTS_ALL AG, OKE_K_HEADERS_FULL_V OKE_HEADER WHERE ACRN.DRAFT_INVOICE_NUM = INV.DRAFT_INVOICE_NUM AND ACRN.PROJECT_ID = INV.PROJECT_ID AND CINV.DRAFT_INVOICE_NUM=INV.CONSOLIDATED_INV_NUM AND CINV.BILL_GROUP_ID=INV.BILL_GROUP_ID AND ACRN.PROJECT_ID = OK.PROJECT_ID(+) AND NVL(ACRN.TASK_ID,0) = NVL(OK.TASK_ID,0) AND CINV.BILL_GROUP_ID=:BILL_GROUP AND CINV.DRAFT_INVOICE_NUM=:CONSINVNUM AND AG.AGREEMENT_ID=INV.AGREEMENT_ID AND ROWNUM=1 GROUP BY OK.CONTRACT_NUMBER, CINV.INVOICE_DATE, CINV.RA_INVOICE_NUMBER, AG.AGREEMENT_NUM, INV.BILL_THROUGH_DATE, OKE_HEADER.START_DATE UNION SELECT DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',AG.AGREEMENT_NUM,OK.CONTRACT_NUMBER) CONTRACT_NUMBER, DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',INV.INVOICE_DATE,OKE_HEADER.START_DATE) INVOICE_DATE, INV.INVOICE_DATE DVP, INV.BILL_THROUGH_DATE BILL_DATE, NVL(INV.RA_INVOICE_NUMBER,' ') RA_INVOICE_NUMBER FROM PA_DRAFT_INVOICE_ACRN ACRN, PA_DRAFT_INVOICES_ALL INV, OKE_PA_BILLING_PARAMS_V OK, PA_AGREEMENTS_ALL AG, OKE_K_HEADERS_FULL_V OKE_HEADER WHERE ACRN.DRAFT_INVOICE_NUM = INV.DRAFT_INVOICE_NUM AND ACRN.PROJECT_ID = INV.PROJECT_ID AND ACRN.PROJECT_ID = OK.PROJECT_ID(+) AND NVL(ACRN.TASK_ID,0) = NVL(OK.TASK_ID,0) AND INV.RA_INVOICE_NUMBER = :ARINVNUM AND AG.AGREEMENT_ID=INV.AGREEMENT_ID AND NVL(OKE_HEADER.PROJECT_ID,0)=NVL(INV.PROJECT_ID,0) AND INV.CONSOLIDATED_INV_NUM IS NULL AND ROWNUM=1 GROUP BY OK.CONTRACT_NUMBER, INV.INVOICE_DATE, INV.BILL_THROUGH_DATE, INV.RA_INVOICE_NUMBER, AG.AGREEMENT_NUM, OKE_HEADER.START_DATE UNION SELECT DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',AG.AGREEMENT_NUM,OK.CONTRACT_NUMBER) CONTRACT_NUMBER, DECODE(NVL(OK.CONTRACT_NUMBER,'X'),'X',INV.INVOICE_DATE,OKE_HEADER.START_DATE) INVOICE_DATE, INV.INVOICE_DATE DVP, INV.BILL_THROUGH_DATE BILL_DATE, NVL(INV.RA_INVOICE_NUMBER,' ') RA_INVOICE_NUMBER FROM PA_DRAFT_INVOICE_ACRN ACRN, PA_DRAFT_INVOICES_ALL INV, OKE_PA_BILLING_PARAMS_V OK, PA_AGREEMENTS_ALL AG, OKE_K_HEADERS_FULL_V OKE_HEADER WHERE ACRN.DRAFT_INVOICE_NUM = INV.DRAFT_INVOICE_NUM AND ACRN.PROJECT_ID = INV.PROJECT_ID AND ACRN.PROJECT_ID = OK.PROJECT_ID(+) AND NVL(ACRN.TASK_ID,0) = NVL(OK.TASK_ID,0) AND INV.PROJECT_ID=:PRJNUM AND INV.DRAFT_INVOICE_NUM=:DINUM AND AG.AGREEMENT_ID=INV.AGREEMENT_ID AND NVL(OKE_HEADER.PROJECT_ID,0)=NVL(INV.PROJECT_ID,0) AND INV.CONSOLIDATED_INV_NUM IS NULL AND ROWNUM=1 GROUP BY OK.CONTRACT_NUMBER, INV.INVOICE_DATE, INV.BILL_THROUGH_DATE, INV.RA_INVOICE_NUMBER, AG.AGREEMENT_NUM, OKE_HEADER.START_DATE Y PA PAXFBPVS_XML AR PA تقرير SF 1034 الفيدرالي Application: المشروعات Source: MGT: تقرير SF 1034 الفيدرالي Short Name: PAXFBPVS_XML DB package: D PA SF 1034 auf Bundesebene Application: Projects Source: PA: SF 1034 auf Bundesebene Short Name: PAXFBPVS_XML DB package: F PA Fédéral - Formulaire standard 1034 Application: Projects Source: MGT : Fédéral - Formulaire standard 1034 Short Name: PAXFBPVS_XML DB package: US PA Federal SF 1034 Application: Projects Source: MGT: Federal SF 1034 Short Name: PAXFBPVS_XML DB package: ZHS PA MGT：联邦 SF 1034 Application: 项目 Source: MGT：联邦 SF 1034 Short Name: PAXFBPVS_XML DB package: BI Publisher :arinvnum :bill_group :consinvnum :dinum :operating_unit :prjnum 1 10 :arinvnum Char Y AR رقم فاتورة المقبوضات D DE-Rechnungsnummer F Numéro de facture client US AR Invoice Number ZHS AR 发票编号