ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4713151A9E05362FB09050512Y SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE DISTRIBUTION TYPE',apdist.line_type_lookup_code) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,PA_Adjustments.Get_Rcv_Info('RECEIPT NUMBER',apdist.rcv_transaction_id) RCV_PAY_Number ,to_Date(PA_Adjustments.Get_Rcv_Info('RECEIPT DATE',apdist.rcv_transaction_id),'DD-MON-YYYY') RCV_PAY_Date ,PA_Adjustments.Get_Rcv_Info('RCV TRANSACTION TYPE',apdist.rcv_transaction_id) RCV_PAY_Transaction_Type ,NULL RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,NULL CDL_Line_Number ,NULL CDL_Reversed_Flag ,NULL CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,ei.billable_flag Billable ,NULL Charge_Account ,NULL PA_Date ,NULL GL_Date ,ei.denom_currency_code Transaction_Currency ,ei.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.denom_raw_cost) PO_Transaction_Raw_Cost ,ei.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,ei.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.acct_raw_cost) PO_Functional_Raw_cost ,ei.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'INVOICES' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,po_vendors vend ,ap_invoices ap ,ap_invoice_lines apline ,ap_invoice_distributions apdist WHERE NOT EXISTS (SELECT NULL FROM pa_cost_distribution_lines cdl WHERE cdl.expenditure_item_id=ei.expenditure_item_id) AND ei.vendor_id=vend.vendor_id AND ap.invoice_id=apline.invoice_id AND apline.invoice_id=apdist.invoice_id AND apline.line_number=apdist.invoice_line_number AND ei.document_header_id=ap.invoice_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_distribution_type<>'SELF_ASSESSED_TAX' AND ei.document_payment_id IS NULL &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP EXPENSE' ,'AP INVOICE' ,'AP NRTAX' ,'AP VARIANCE' ,'INTERPROJECT_AP_INVOICES' ,'AP ERV') AND (:P_TRANSACTION_TYPE='ALL' OR (:P_TRANSACTION_TYPE='VI' AND (ap.invoice_type_lookup_code<>'EXPENSE REPORT' OR (ap.source='CREDIT_CARD' AND ap.invoice_type_lookup_code NOT IN ('STANDARD','MIXED','CREDIT')))) OR (:P_TRANSACTION_TYPE='ER' AND (ap.invoice_type_lookup_code='EXPENSE REPORT' OR (ap.source='CREDIT CARD' AND ap.invoice_type_lookup_code IN ('STANDARD','MIXED','CREDIT'))))) AND ei.system_linkage_function IN ('VI','ER') AND :P_FROM_GL_DATE IS NULL AND :P_TO_GL_DATE IS NULL AND :P_FROM_GL_ACCOUNT IS NULL AND :P_TO_GL_ACCOUNT IS NULL &P_INV_REV_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('TRANSACTION_TYPE',ei.document_distribution_type) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,PA_Adjustments.Get_Rcv_Info('RECEIPT NUMBER',apdist.rcv_transaction_id) RCV_PAY_Number ,to_Date(PA_Adjustments.Get_Rcv_Info('RECEIPT DATE',apdist.rcv_transaction_id),'DD-MON-YYYY') RCV_PAY_Date ,PA_Adjustments.Get_Rcv_Info('RCV TRANSACTION TYPE',apdist.rcv_transaction_id) RCV_PAY_Transaction_Type ,NULL RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,NULL CDL_Line_Number ,NULL CDL_Reversed_Flag ,NULL CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,ei.billable_flag Billable ,NULL Charge_Account ,NULL PA_Date ,NULL GL_Date ,ei.denom_currency_code Transaction_Currency ,ei.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.denom_raw_cost) PO_Transaction_Raw_Cost ,ei.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,ei.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.acct_raw_cost) PO_Functional_Raw_cost ,ei.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'INVOICES' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,po_vendors vend ,ap_invoices ap ,ap_invoice_lines apline ,ap_self_assessed_tax_dist_all apdist WHERE NOT EXISTS (SELECT NULL FROM pa_cost_distribution_lines cdl WHERE cdl.expenditure_item_id=ei.expenditure_item_id) AND ei.vendor_id=vend.vendor_id AND ap.invoice_id=apline.invoice_id AND apline.invoice_id=apdist.invoice_id AND apline.line_number=apdist.invoice_line_number AND ei.document_header_id=ap.invoice_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_distribution_type='SELF_ASSESSED_TAX' AND ei.document_payment_id IS NULL &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP NRTAX') AND (:P_TRANSACTION_TYPE='ALL' OR (:P_TRANSACTION_TYPE='VI' AND (ap.invoice_type_lookup_code<>'EXPENSE REPORT' OR (ap.source='CREDIT_CARD' AND ap.invoice_type_lookup_code NOT IN ('STANDARD','MIXED','CREDIT')))) OR (:P_TRANSACTION_TYPE='ER' AND (ap.invoice_type_lookup_code='EXPENSE REPORT' OR (ap.source='CREDIT CARD' AND ap.invoice_type_lookup_code IN ('STANDARD','MIXED','CREDIT'))))) AND ei.system_linkage_function IN ('VI','ER') AND :P_FROM_GL_DATE IS NULL AND :P_TO_GL_DATE IS NULL AND :P_FROM_GL_ACCOUNT IS NULL AND :P_TO_GL_ACCOUNT IS NULL &P_INV_REV_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE DISTRIBUTION TYPE',apdist.line_type_lookup_code) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,PA_Adjustments.Get_Rcv_Info('RECEIPT NUMBER',apdist.rcv_transaction_id) RCV_PAY_Number ,to_Date(PA_Adjustments.Get_Rcv_Info('RECEIPT DATE',apdist.rcv_transaction_id),'DD-MON-YYYY') RCV_PAY_Date ,PA_Adjustments.Get_Rcv_Info('RCV TRANSACTION TYPE',apdist.rcv_transaction_id) RCV_PAY_Transaction_Type ,NULL RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,cdl.line_num CDL_Line_Number ,cdl.reversed_flag CDL_Reversed_Flag ,cdl.line_num_reversed CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,cdl.billable_flag Billable ,fnd_flex_ext.get_segs('SQLGL','GL#',:P_COA_ID,cdl.dr_code_combination_id) Charge_Account ,cdl.pa_date PA_Date ,cdl.gl_date GL_Date ,ei.denom_currency_code Transaction_Currency ,cdl.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.denom_raw_cost) PO_Transaction_Raw_Cost ,cdl.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,cdl.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.acct_raw_cost) PO_Functional_Raw_cost ,cdl.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'INVOICES' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,pa_cost_distribution_lines_all cdl ,po_vendors vend ,ap_invoices_all ap ,ap_invoice_lines_all apline ,ap_invoice_distributions_all apdist WHERE ei.expenditure_item_id=cdl.expenditure_item_id AND cdl.line_type='R' AND ei.document_payment_id IS NULL AND ei.vendor_id=vend.vendor_id AND ap.invoice_id=apline.invoice_id AND apline.invoice_id=apdist.invoice_id AND apline.line_number=apdist.invoice_line_number AND ei.document_header_id=ap.invoice_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_distribution_type<>'SELF_ASSESSED_TAX' &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP EXPENSE' ,'AP INVOICE' ,'AP NRTAX' ,'AP VARIANCE' ,'INTERPROJECT_AP_INVOICES' ,'AP ERV') AND (:P_TRANSACTION_TYPE='ALL' OR (:P_TRANSACTION_TYPE='VI' AND (ap.invoice_type_lookup_code<>'EXPENSE REPORT' OR (ap.source='CREDIT_CARD' AND ap.invoice_type_lookup_code NOT IN ('STANDARD','MIXED','CREDIT')))) OR (:P_TRANSACTION_TYPE='ER' AND (ap.invoice_type_lookup_code='EXPENSE REPORT' OR (ap.source='CREDIT CARD' AND ap.invoice_type_lookup_code IN ('STANDARD','MIXED','CREDIT'))))) AND ei.system_linkage_function IN ('VI','ER') AND cdl.gl_date BETWEEN NVL(:P_FROM_GL_DATE,cdl.gl_date) AND NVL(:P_TO_GL_DATE,cdl.gl_date) AND EXISTS (SELECT NULL FROM gl_code_combinations cc WHERE cdl.dr_code_combination_id=cc.code_combination_id and &P_ACC_WHERE) &P_INV_REV_ADJ_WHERE &P_INV_PA_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('TRANSACTION_TYPE',ei.document_distribution_type) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,PA_Adjustments.Get_Rcv_Info('RECEIPT NUMBER',apdist.rcv_transaction_id) RCV_PAY_Number ,to_Date(PA_Adjustments.Get_Rcv_Info('RECEIPT DATE',apdist.rcv_transaction_id),'DD-MON-YYYY') RCV_PAY_Date ,PA_Adjustments.Get_Rcv_Info('RCV TRANSACTION TYPE',apdist.rcv_transaction_id) RCV_PAY_Transaction_Type ,NULL RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,cdl.line_num CDL_Line_Number ,cdl.reversed_flag CDL_Reversed_Flag ,cdl.line_num_reversed CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,cdl.billable_flag Billable ,fnd_flex_ext.get_segs('SQLGL','GL#',:P_COA_ID,cdl.dr_code_combination_id) Charge_Account ,cdl.pa_date PA_Date ,cdl.gl_date GL_Date ,ei.denom_currency_code Transaction_Currency ,cdl.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.denom_raw_cost) PO_Transaction_Raw_Cost ,cdl.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,cdl.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.acct_raw_cost) PO_Functional_Raw_cost ,cdl.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'INVOICES' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,pa_cost_distribution_lines_all cdl ,po_vendors vend ,ap_invoices_all ap ,ap_invoice_lines_all apline ,ap_self_assessed_tax_dist_all apdist WHERE ei.expenditure_item_id=cdl.expenditure_item_id AND cdl.line_type='R' AND ei.document_payment_id IS NULL AND ei.vendor_id=vend.vendor_id AND ap.invoice_id=apline.invoice_id AND apline.invoice_id=apdist.invoice_id AND apline.line_number=apdist.invoice_line_number AND ei.document_header_id=ap.invoice_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_distribution_type='SELF_ASSESSED_TAX' &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP NRTAX') AND (:P_TRANSACTION_TYPE='ALL' OR (:P_TRANSACTION_TYPE='VI' AND (ap.invoice_type_lookup_code<>'EXPENSE REPORT' OR (ap.source='CREDIT_CARD' AND ap.invoice_type_lookup_code NOT IN ('STANDARD','MIXED','CREDIT')))) OR (:P_TRANSACTION_TYPE='ER' AND (ap.invoice_type_lookup_code='EXPENSE REPORT' OR (ap.source='CREDIT CARD' AND ap.invoice_type_lookup_code IN ('STANDARD','MIXED','CREDIT'))))) AND ei.system_linkage_function IN ('VI','ER') AND cdl.gl_date BETWEEN NVL(:P_FROM_GL_DATE,cdl.gl_date) AND NVL(:P_TO_GL_DATE,cdl.gl_date) AND EXISTS (SELECT NULL FROM gl_code_combinations cc WHERE cdl.dr_code_combination_id=cc.code_combination_id and &P_ACC_WHERE) &P_INV_REV_ADJ_WHERE &P_INV_PA_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',rcvtxn.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',rcvtxn.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',rcvtxn.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Inv_Info('INVOICE TYPE',:P_INVOICE_ID) Invoice_Type ,PA_Adjustments.Get_Inv_Info('INVOICE NUMBER',:P_INVOICE_ID) Invoice_Number ,to_date(PA_Adjustments.Get_Inv_Info('INVOICE DATE',:P_INVOICE_ID),'DD-MON-YYYY') Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',rcvtxn.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',rcvtxn.po_distribution_id),NULL) AP_PO_Number ,to_date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',rcvtxn.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',rcvtxn.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',rcvtxn.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',rcvtxn.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',rcvtxn.po_distribution_id),NULL) PO_Dist_Type ,NULL Invoice_Distribution_ID ,NULL Invoice_Line_Num ,NULL Invoice_Line_Type ,NULL Invoice_Dist_Line_Num ,NULL Invoice_Dist_Type ,NULL AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',rcvtxn.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',rcvtxn.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',rcvtxn.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',rcvtxn.po_distribution_id),NULL) AP_PO_Dist_Type ,rcv.receipt_num RCV_PAY_Number ,rcvtxn.transaction_date RCV_PAY_Date ,PA_Adjustments.Get_Displayed_Field('RCV TRANSACTION TYPE',rcvtxn.transaction_type) RCV_PAY_Transaction_Type ,NVL((SELECT 'Y' FROM dual WHERE 0= (SELECT sum(rcvtxnrev.quantity) FROM rcv_transactions rcvtxnrev WHERE rcvtxnrev.parent_transaction_id=rcvtxn.transaction_id OR rcvtxnrev.transaction_id=rcvtxn.transaction_id)),'N') RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,NULL CDL_Line_Number ,NULL CDL_Reversed_Flag ,NULL CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,ei.billable_flag Billable ,NULL Charge_Account ,NULL PA_Date ,NULL GL_Date ,ei.denom_currency_code Transaction_Currency ,ei.denom_raw_cost Functional_Raw_cost ,ei.denom_raw_cost PO_Transaction_Raw_Cost ,NULL AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,ei.acct_raw_cost Functional_Raw_cost ,ei.acct_raw_cost PO_Functional_Raw_cost ,NULL AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'RECEIPTS' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,po_vendors vend ,rcv_shipment_headers rcv ,rcv_transactions rcvtxn WHERE NOT EXISTS (SELECT NULL FROM pa_cost_distribution_lines cdl WHERE cdl.expenditure_item_id=ei.expenditure_item_id) AND ei.vendor_id=vend.vendor_id AND rcvtxn.transaction_id=ei.document_distribution_id AND rcv.shipment_header_id=rcvtxn.shipment_header_id &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ei.transaction_source IN ('PO RECEIPT' ,'PO RECEIPT NRTAX' ,'PO RECEIPT NRTAX PRICE ADJ' ,'PO RECEIPT PRICE ADJ') AND :P_TRANSACTION_TYPE IN ('ALL','RCV') AND (:P_INVOICE_ID IS NULL OR rcvtxn.transaction_id IN (SELECT ap_dist.rcv_transaction_id FROM ap_invoice_distributions_all ap_dist WHERE ap_dist.invoice_id=:P_INVOICE_ID)) AND rcvtxn.po_header_id=NVL(:P_PO_HEADER_ID,rcvtxn.po_header_id) AND ei.system_linkage_function='VI' AND :P_FROM_GL_DATE IS NULL AND :P_TO_GL_DATE IS NULL AND :P_FROM_GL_ACCOUNT IS NULL AND :P_TO_GL_ACCOUNT IS NULL &P_RCV_REV_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',rcvtxn.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',rcvtxn.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',rcvtxn.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Inv_Info('INVOICE TYPE',:P_INVOICE_ID) Invoice_Type ,PA_Adjustments.Get_Inv_Info('INVOICE NUMBER',:P_INVOICE_ID) Invoice_Number ,to_date(PA_Adjustments.Get_Inv_Info('INVOICE DATE',:P_INVOICE_ID),'DD-MON-YYYY') Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',rcvtxn.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',rcvtxn.po_distribution_id),NULL) AP_PO_Number ,to_date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',rcvtxn.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',rcvtxn.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',rcvtxn.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',rcvtxn.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',rcvtxn.po_distribution_id),NULL) PO_Dist_Type ,NULL Invoice_Distribution_ID ,NULL Invoice_Line_Num ,NULL Invoice_Line_Type ,NULL Invoice_Dist_Line_Num ,NULL Invoice_Dist_Type ,NULL AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',rcvtxn.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',rcvtxn.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',rcvtxn.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',rcvtxn.po_distribution_id),NULL) AP_PO_Dist_Type ,rcv.receipt_num RCV_PAY_Number ,rcvtxn.transaction_date RCV_PAY_Date ,PA_Adjustments.Get_Displayed_Field('RCV TRANSACTION TYPE',rcvtxn.transaction_type) RCV_PAY_Transaction_Type ,NVL((SELECT 'Y' FROM dual WHERE 0= (SELECT sum(rcvtxnrev.quantity) FROM rcv_transactions rcvtxnrev WHERE rcvtxnrev.parent_transaction_id=rcvtxn.transaction_id OR rcvtxnrev.transaction_id=rcvtxn.transaction_id)),'N') RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,cdl.line_num CDL_Line_Number ,cdl.reversed_flag CDL_Reversed_Flag ,cdl.line_num_reversed CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,cdl.billable_flag Billable ,fnd_flex_ext.get_segs('SQLGL','GL#',:P_COA_ID,cdl.dr_code_combination_id) Charge_Account ,cdl.pa_date PA_Date ,cdl.gl_date GL_Date ,ei.denom_currency_code Transaction_Currency ,cdl.denom_raw_cost Functional_Raw_cost ,cdl.denom_raw_cost PO_Transaction_Raw_Cost ,NULL AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,cdl.acct_raw_cost Functional_Raw_cost ,cdl.acct_raw_cost PO_Functional_Raw_cost ,NULL AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'RECEIPTS' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,pa_cost_distribution_lines_all cdl ,po_vendors vend ,rcv_shipment_headers rcv ,rcv_transactions rcvtxn WHERE ei.expenditure_item_id=cdl.expenditure_item_id AND cdl.line_type='R' AND ei.vendor_id=vend.vendor_id AND rcvtxn.transaction_id=ei.document_distribution_id AND rcv.shipment_header_id=rcvtxn.shipment_header_id &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ei.transaction_source IN ('PO RECEIPT' ,'PO RECEIPT NRTAX' ,'PO RECEIPT NRTAX PRICE ADJ' ,'PO RECEIPT PRICE ADJ') AND :P_TRANSACTION_TYPE IN ('ALL','RCV') AND (:P_INVOICE_ID IS NULL OR rcvtxn.transaction_id IN (SELECT ap_dist.rcv_transaction_id FROM ap_invoice_distributions_all ap_dist WHERE ap_dist.invoice_id=:P_INVOICE_ID)) AND rcvtxn.po_header_id=NVL(:P_PO_HEADER_ID,rcvtxn.po_header_id) AND ei.system_linkage_function='VI' AND cdl.gl_date BETWEEN NVL(:P_FROM_GL_DATE,cdl.gl_date) AND NVL(:P_TO_GL_DATE,cdl.gl_date) AND EXISTS (SELECT NULL FROM gl_code_combinations cc WHERE cdl.dr_code_combination_id=cc.code_combination_id and &P_ACC_WHERE) &P_RCV_REV_ADJ_WHERE &P_RCV_PA_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE DISTRIBUTION TYPE',apdist.line_type_lookup_code) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO TYPE',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,to_char(apchk.check_number) RCV_PAY_Number ,apchk.check_date RCV_PAY_Date ,PA_Adjustments.Get_Displayed_Field('PAYMENT TYPE',apchk.payment_type_flag) RCV_PAY_Transaction_Type ,appay.reversal_flag RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,NULL CDL_Line_Number ,NULL CDL_Reversed_Flag ,NULL CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,ei.billable_flag Billable ,NULL Charge_Account ,NULL PA_Date ,NULL GL_Date ,ei.denom_currency_code Transaction_Currency ,ei.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.denom_raw_cost) PO_Transaction_Raw_Cost ,ei.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,ei.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),ei.acct_raw_cost) PO_Functional_Raw_cost ,ei.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'PAYMENTS' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,po_vendors vend ,ap_invoices ap ,ap_invoice_lines apline ,ap_invoice_distributions_all apdist ,ap_invoice_payments appay ,ap_checks apchk WHERE NOT EXISTS (SELECT NULL FROM pa_cost_distribution_lines cdl WHERE cdl.expenditure_item_id=ei.expenditure_item_id) AND ei.vendor_id=vend.vendor_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_line_number=apline.line_number AND ei.document_header_id=ap.invoice_id AND ap.invoice_id=apline.invoice_id AND ei.document_payment_id=appay.invoice_payment_id AND apchk.check_id=appay.check_id &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ei.document_payment_id IS NOT NULL AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP EXPENSE' ,'AP INVOICE' ,'AP NRTAX' ,'AP DISCOUNTS' ,'AP VARIANCE' ,'INTERPROJECT_AP_INVOICES' ,'AP ERV') AND :P_TRANSACTION_TYPE IN ('ALL','PAY') AND :P_FROM_GL_DATE IS NULL AND :P_TO_GL_DATE IS NULL AND :P_FROM_GL_ACCOUNT IS NULL AND :P_TO_GL_ACCOUNT IS NULL &P_PAY_REV_ADJ_WHERE UNION ALL SELECT vend.segment1 Supplier_Number ,vend.vendor_name Supplier_Name ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) PO_Header_ID ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) PO_Number ,to_date(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') PO_Date ,PA_Adjustments.Get_Displayed_Field('INVOICE TYPE',ap.invoice_type_lookup_code) Invoice_Type ,ap.invoice_num Invoice_Number ,ap.invoice_date Invoice_Date ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id),NULL)) AP_PO_Header_ID ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO NUM',apdist.po_distribution_id),NULL) AP_PO_Number ,to_Date(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DATE',apdist.po_distribution_id),NULL),'DD-MON-YYYY') AP_PO_Date ,DECODE(:P_SORT_ORDER,'PO',apdist.po_distribution_id,NULL) PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) PO_Dist_Num ,DECODE(:P_SORT_ORDER,'PO',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL) PO_Dist_Type ,apdist.invoice_distribution_id Invoice_Distribution_ID ,apline.line_number Invoice_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE LINE TYPE',apline.line_type_lookup_code) Invoice_Line_Type ,apdist.distribution_line_number Invoice_Dist_Line_Num ,PA_Adjustments.Get_Displayed_Field('INVOICE DISTRIBUTION TYPE',apdist.line_type_lookup_code) Invoice_Dist_Type ,apdist.reversal_flag AP_Reversal_Flag ,DECODE(:P_SORT_ORDER,'AP',apdist.po_distribution_id,NULL) AP_PO_Distribution_ID ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO LINE NUM',apdist.po_distribution_id),NULL)) AP_PO_Line_Num ,to_number(DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL)) AP_PO_Dist_Num ,DECODE(:P_SORT_ORDER,'AP',PA_Adjustments.Get_PO_Info('PO DIST NUM',apdist.po_distribution_id),NULL) AP_PO_Dist_Type ,to_char(apchk.check_number) RCV_PAY_Number ,apchk.check_date RCV_PAY_Date ,PA_Adjustments.Get_Displayed_Field('PAYMENT TYPE',apchk.payment_type_flag) RCV_PAY_Transaction_Type ,appay.reversal_flag RCV_PAY_Reversal_Flag ,pa_utils3.GetCachedOUName(ei.override_to_organization_id) Expenditure_Organization ,ei.expenditure_type Expenditure_Type ,ei.expenditure_item_date Expenditure_Item_Date ,ei.expenditure_item_id Transaction_ID ,ei.net_zero_adjustment_flag EI_Adjusted_Flag ,ei.adjusted_expenditure_item_id EI_Adjust_ID ,ei.transferred_from_exp_item_id EI_Transfer_ID ,cdl.line_num CDL_Line_Number ,cdl.reversed_flag CDL_Reversed_Flag ,cdl.line_num_reversed CDL_Reversal_Line_Number ,pa_utils3.getcachedprojnum(ei.project_id) Project_Number ,pa_utils3.getcachedtasknum(ei.task_id) Task_Number ,cdl.billable_flag Billable ,fnd_flex_ext.get_segs('SQLGL','GL#',:P_COA_ID,cdl.dr_code_combination_id) Charge_Account ,cdl.pa_date PA_Date ,cdl.gl_date GL_Date ,ei.denom_currency_code Transaction_Currency ,cdl.denom_raw_cost Transaction_Raw_Cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.denom_raw_cost) PO_Transaction_Raw_Cost ,cdl.denom_raw_cost AP_Transaction_Raw_Cost ,ei.acct_currency_code Functional_Currency ,cdl.acct_raw_cost Functional_Raw_cost ,DECODE(apdist.po_distribution_id,NULL,to_number(NULL),cdl.acct_raw_cost) PO_Functional_Raw_cost ,cdl.acct_raw_cost AP_Functional_Raw_cost ,ei.transaction_source Transaction_Source ,'PAYMENTS' Transaction_Type, PA_PAXSIADJ_XMLP_PKG.cf_award_numberformula(ei.expenditure_item_id) CF_AWARD_NUMBER FROM pa_expenditure_items ei ,pa_cost_distribution_lines_all cdl ,po_vendors vend ,ap_invoices_all ap ,ap_invoice_lines apline ,ap_invoice_distributions_all apdist ,ap_invoice_payments_all appay ,ap_checks apchk WHERE ei.expenditure_item_id=cdl.expenditure_item_id AND cdl.line_type='R' AND ei.vendor_id=vend.vendor_id AND ei.document_distribution_id=apdist.invoice_distribution_id AND ei.document_line_number=apline.line_number AND ei.document_header_id=ap.invoice_id AND ap.invoice_id=apline.invoice_id AND ei.document_payment_id=appay.invoice_payment_id AND apchk.check_id=appay.check_id &P_GMS_WHERE AND pa_utils3.GetCachedProjNum(ei.project_id) BETWEEN NVL(:P_FROM_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND NVL(:P_TO_PROJECT_NUMBER,pa_utils3.GetCachedProjNum(ei.project_id)) AND ei.task_id=NVL(:P_TASK_ID,ei.task_id) AND ei.override_to_organization_id=NVL(:P_EXPENDITURE_ORG_ID,ei.override_to_organization_id) AND vend.vendor_id=NVL(:P_VENDOR_ID,vend.vendor_id) AND ei.document_payment_id IS NOT NULL AND ap.invoice_id=NVL(:P_INVOICE_ID,ap.invoice_id) AND (:P_PO_HEADER_ID IS NULL OR (:P_PO_HEADER_ID IS NOT NULL AND apdist.po_distribution_id IS NOT NULL AND PA_Adjustments.Get_PO_Info('PO HEADER ID',apdist.po_distribution_id)=:P_PO_HEADER_ID)) AND ei.transaction_source IN ('AP EXPENSE' ,'AP INVOICE' ,'AP NRTAX' ,'AP DISCOUNTS' ,'AP VARIANCE' ,'INTERPROJECT_AP_INVOICES' ,'AP ERV') AND :P_TRANSACTION_TYPE IN ('ALL','PAY') AND cdl.gl_date BETWEEN NVL(:P_FROM_GL_DATE,cdl.gl_date) AND NVL(:P_TO_GL_DATE,cdl.gl_date) AND EXISTS (SELECT NULL FROM gl_code_combinations cc WHERE cdl.dr_code_combination_id=cc.code_combination_id and &P_ACC_WHERE) &P_PAY_REV_ADJ_WHERE &P_PAY_PA_ADJ_WHERE ORDER BY Supplier_Name &P_ORDER_BY ,Transaction_ID ,CDL_Line_Number PA PAXSIADJ_XML AR PA تقرير تدقيق تكلفة المورّد (بتنسيق XML) Imported from BI Publisher Description: للإبلاغ عن حركات تكلفة موردين. يمكن استخدام التقريرللمساعدة في تسوية المشروعات لأوراكل مع المدفوعات والمشتريات والأستاذ العام Application: المشروعات Source: AUD: تقرير تدقيق تكلفة المورّد (بتنسيق XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG D PA Lieferantenkosten - Prüfprotokoll Imported from BI Publisher Description: Programm zur Auswertung von Lieferantenkostentransaktionen. Mithilfe der Auswertung können Sie Oracle Projects mit Oracle Kreditoren, Einkauf und Rechnungswesen abstimmen. Application: Projects Source: PA: Lieferantenkosten - Prüfprotokoll (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG E PA Auditoría de Costes de Proveedor Imported from BI Publisher Description: El programa genera un informe sobre transacciones de costes de proveedores. Puede servirse del informe para reconciliar Oracle Projects y Oracle Payables, Oracle Purchasing y Oracle General Ledger. Application: Projects Source: AUD: Auditoría de Costes de Proveedor (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG F PA Etat d'audit des coûts fournisseur Imported from BI Publisher Description: Ce programme édite un état sur les mouvements de coûts fournisseur. Cet état vous aide à effectuer un rapprochement entre Projects et Payables, Purchasing et General Ledger. Application: Projects Source: AUD : Etat d'audit des coûts fournisseur (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG I PA rapporto Audit costi fornitore Imported from BI Publisher Description: Il programma di esecuzione del rapporto sulle transazioni dei costi fornitore. Il rapporto contribuiscono alla sincronizzazione di Oracle Projects con Oracle Payables, Oracle Purchasing e and Oracle General Ledger. Application: Projects Source: AUD: rapporto Audit costi fornitore (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG JA PA 仕入先原価監査レポート Imported from BI Publisher Description: このプログラムは仕入先原価取引をレポートします。 このレポートは、 Oracle ProjectsとOracle Payables、 Oracle Purchasing、 Oracle General Ledgerとの消込の実行時に援用できます。 Application: Projects Source: AUD: 仕入先原価監査レポート(XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG KO PA 공급자 원가 감사 보고서 Imported from BI Publisher Description: 공급자 원가 거래에 대한 프로그램 보고서입니다. Oracle Projects와 Oracle Payables, Oracle Purchasing, Oracle General Ledger 간에 대사할 때 이 보고서를 유용하게 사용할 수 있습니다. Application: Projects Source: AUD: 공급자 원가 감사 보고서(XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG PTB PA Relatório de Auditoria do Custo do Fornecedor Imported from BI Publisher Description: Relatórios do programa sobre as transações do custo do fornecedor. É possível usar o relatório como uma ajuda para reconciliar o Oracle Projects com Oracle Payables, Oracle Purchasing e Oracle General Ledger. Application: Projetos Source: AUD: Relatório de Auditoria do Custo do Fornecedor (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG RU PA отчет об аудите затрат поставщиков Imported from BI Publisher Description: Программа отчета о транз. с затрат. поставщиков. Отчет можно использ. как вспомогательное ср-во для выверки данных УП по КР, ЗП и ГК. Application: Проекты Source: АУД: отчет об аудите затрат поставщиков (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG S PA Leverantörskostnader - kontrollrapport Imported from BI Publisher Description: Programmet används för att rapportera om leverantörskostnadstransaktioner. Du kan använda rapporten som ett hjälpmedel för att stämma av Oracle Projects med Oracle Payables, Oracle Purchasing och Oracle General Ledger. Application: Projects Source: AUD: Leverantörskostnader - kontrollrapport (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG TR PA Tedarikçi Maliyeti Denetim Raporu Imported from BI Publisher Description: Program tedarikçi maliyet işlemleriyle ilgili rapor verir. Raporu, Oracle Projeler'i Oracle Borçlar Muhasebesi, Oracle Satınalma ve Oracle Genel Muhasebe ile mutabık kılmanıza yardımcı olması için kullanabilirsiniz Application: Proje Yönetimi Source: AUD: Tedarikçi Maliyeti Denetim Raporu (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG US PA Supplier Cost Audit Imported from BI Publisher Description: The program reports on supplier cost transactions. You can use the report as an aid to reconcile Oracle Projects with Oracle Payables, Oracle Purchasing, and Oracle General Ledger. Application: Projects Source: AUD: Supplier Cost Audit Report (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG ZHS PA AUD：供应商成本审核报表 Imported from BI Publisher Description: 涉及供应商成本事务处理的程序报表。可使用该报表来帮助调节 Oracle Projects 与 Oracle Payables、Oracle Purchasing 及 Oracle General Ledger。 Application: 项目 Source: AUD：供应商成本审核报表 (XML) Short Name: PAXSIADJ_XML DB package: PA_PAXSIADJ_XMLP_PKG BI Publisher &p_acc_where &p_gms_where &p_inv_pa_adj_where &p_inv_rev_adj_where &p_order_by &p_pay_pa_adj_where &p_pay_rev_adj_where &p_rcv_pa_adj_where &p_rcv_rev_adj_where :operating_unit :p_acc_where :p_adjustment_type :p_coa_id :p_conc_request_id :p_currency_code :p_debug_mode :p_expenditure_org_id :p_from_award_number :p_from_gl_account :p_from_gl_date :p_from_gl_period :p_from_project_number :p_gms_where :p_inv_pa_adj_where :p_inv_rev_adj_where :p_invoice_id :p_is_grants_installed :p_ledger_id :p_order_by :p_pay_pa_adj_where :p_pay_rev_adj_where :p_period_set_name :p_po_header_id :p_rcv_pa_adj_where :p_rcv_rev_adj_where :p_sort_order :p_task_id :p_to_award_number :p_to_gl_account :p_to_gl_date :p_to_gl_period :p_to_project_number :p_transaction_type :p_vendor_id 1 -20 :p_coa_id LOV Oracle PA_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from pa_implementations_all imp,gl_sets_of_books gl where imp.set_of_books_id=gl.set_of_books_id and imp.org_id=mo_global.get_current_org_id order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books g, pa_implementations p WHERE g.set_of_books_id = p.set_of_books_id Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kennung des Kontenplans E Id Plan de Cuentas Identificador del plan de cuentas F ID plan de comptes Identifiant du plan de comptes I Id piano dei conti L'identificativo del piano dei conti JA 勘定体系ID 勘定体系の識別子 KO 계정 코드집 ID 계정 코드집 식별자 PTB ID do Plano de Contas Identificador de planos de contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Id:t för kontoplanen TR Hesap Planı No Hesap planı tanımlayıcısı US Chart of Accounts ID Identifier of the chart of accounts ZHS 科目表标识 科目表的标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_from_project_number Char AR P_FROM_PROJECT_NUMBER بداية مدى رقم المشروع D P_FROM_PROJECT_NUMBER Erste Nummer des Projektnummernbereichs E P_FROM_PROJECT_NUMBER Inicio de rango de números de proyecto F P_FROM_PROJECT_NUMBER Début de la fourchette de numéros de projet I P_FROM_PROJECT_NUMBER Inizio dell'intervallo dei numeri di progetto JA P_FROM_PROJECT_NUMBER プロジェクト番号の範囲の開始 KO P_FROM_PROJECT_NUMBER 프로젝트 번호 범위 시작 PTB P_FROM_PROJECT_NUMBER Início da faixa do número do projeto RU P_FROM_PROJECT_NUMBER Начало диапазона номеров проектов S P_FROM_PROJECT_NUMBER Start på projektnummerintervallet TR P_FROM_PROJECT_NUMBER Proje numara aralığının başlangıcı US P_FROM_PROJECT_NUMBER Start of the project number range ZHS P_FROM_PROJECT_NUMBER 项目编号范围的起始编号 4 20 :p_to_project_number Char AR P_TO_PROJECT_NUMBER نهاية مدى رقم المشروع D P_TO_PROJECT_NUMBER Letzte Nummer des Projektnummernbereichs E P_TO_PROJECT_NUMBER Fin de rango de números de proyecto F P_TO_PROJECT_NUMBER Fin de la fourchette de numéros de projet I P_TO_PROJECT_NUMBER Fine dell'intervallo dei numeri di progetto JA P_TO_PROJECT_NUMBER プロジェクト番号の範囲の終了 KO P_TO_PROJECT_NUMBER 프로젝트 번호 범위 종료 PTB P_TO_PROJECT_NUMBER Término da faixa do número do projeto RU P_TO_PROJECT_NUMBER Конец диапазона номеров проектов S P_TO_PROJECT_NUMBER Slut på projektnummerintervallet TR P_TO_PROJECT_NUMBER Proje numara aralığının sonu US P_TO_PROJECT_NUMBER End of the project number range ZHS P_TO_PROJECT_NUMBER 项目编号范围的终止编号 5 30 :p_task_id LOV Oracle PA_SRS_PROJ_TASK Y select t.task_id id, t.task_number value, null description from pa_tasks t where t.project_id=( select p.project_id from pa_projects_all p where p.segment1=:$flex$.p_from_project_number) and :$flex$.p_from_project_number=:$flex$.p_to_project_number order by t.task_number AR رقم المهمة المهمة التي تم تحميل بنود المصروفات عليها D Teilprojektnummer Teilprojekt, für das die Aufwandsposten angefallen sind E Número de Tarea Tarea que ha incurrido en conceptos de gasto F Numéro de tâche Tâche qui a engagé les dépenses I Numero task Il task che ha sostenuto le voci di spesa JA タスク番号 支出項目の発生元であるタスク KO 태스크 번호 비용 항목을 발생시킨 태스크 PTB Nr. da Tarefa Tarefa que incorreu os itens de dispêndio RU Номер задачи Задача, несущая расходы S Uppgiftsnr Uppgift som gav upphov till utgiftsposterna TR İş Numarası Harcama kalemlerini gerçekleştiren iş US Task Number Task that incurred the expenditure items ZHS 任务编号 发生支出项的任务 6 40 :p_expenditure_org_id LOV Oracle PA_SRS_EXPENDITURE_ORG Y select organization_id id, name value, null description from pa_organizations_expend_v order by name AR تنظيم المصروفات التنظيم الذي تحمل بنود المصروفات D Aufwandsorganisation Für die Aufwandsposten verantwortliche Organisation E Organización de Gasto Organización que ha incurrido en conceptos de gasto F Organisation des dépenses Organisation qui a engagé les dépenses I Organizzazione di spesa L'organizzazione che ha sostenuto le voci di spesa JA 支出組織 支出項目の発生元である組織 KO 비용 조직 비용 항목을 발생시킨 조직 PTB Organização de Dispêndio Organização que incorreu itens de dispêndio RU Расходующая организация Организация, несущая расходы S Utgiftsorganisation Organisation som gav upphov till utgiftsposterna TR Harcama Organizasyonu Harcama kalemlerini gerçekleştiren organizasyon US Expenditure Organization Organization that incurred the expenditure items ZHS 支出组织 发生支出项的组织 7 50 :p_vendor_id LOV Oracle PA_SRS_SUPPLIER Y select v.vendor_id id, v.vendor_name value, null description from po_vendors v where exists ( select null from ap_invoices_all i,ap_invoice_distributions_all d where v.vendor_id=i.vendor_id and i.invoice_id=d.invoice_id and d.project_id is not null) order by v.vendor_name AR اسم المورد المورّد المرتبط ببنود المصروفات D Lieferantenname Lieferant, der den Aufwandsposten zugeordnet ist E Nombre de Proveedor Proveedor relacionado con los conceptos de gasto F Nom du fournisseur Fournisseur lié aux dépenses I Nome fornitore Il fornitore correlato alle voci di spesa JA 仕入先名 支出項目に関連する仕入先 KO 공급자명 비용 항목과 관련된 공급자 PTB Nome do Fornecedor Fornecedor relacionado aos itens de dispêndio RU Имя поставщика Поставщик, связанный со статьями расхода S Leverantör Leverantör som är relaterad till utgiftsposterna TR Tedarikçi Adı Harcama kalemleriyle ilgili tedarikçi US Supplier Name Supplier related to the expenditure items ZHS 供应商名称 与支出项相关的供应商 8 60 :p_invoice_id LOV Oracle PA_SRS_SUPPLIER_INVOICE Y select i.invoice_id id, i.invoice_num value, null description from ap_invoices i where exists ( select null from ap_invoice_distributions_all d where i.invoice_id=d.invoice_id and d.project_id is not null) order by i.invoice_num AR رقم الفاتورة فاتورة المورّد المرتبطة ببنود المصروفات D Rechnungsnummer Lieferantenrechnung, die den Aufwandsposten zugeordnet ist E Número de Factura Factura de proveedor relacionada con los conceptos de gasto F Numéro de facture Facture fournisseur liée aux dépenses I Numero fattura La fattura fornitore correlata alle voci di spesa JA 請求書番号 支出項目に関連する仕入先請求書 KO 송장 번호 비용 항목과 관련된 공급자 송장 PTB Nr. da NFF NFF do fornecedor relacionada aos itens de dispêndio RU Номер счета-фактуры Счет-фактура поставщика, связанный со статьями расхода S Fakturanummer Leverantörsfaktura som är relaterad till utgiftsposterna TR Fatura Numarası Harcama kalemleriyle ilgili tedarikçi faturası US Invoice Number Supplier invoice related to the expenditure items ZHS 发票编号 与支出项相关的供应商发票 9 70 :p_po_header_id LOV Oracle PA_SRS_PURCHASE_ORDER Y select p.po_header_id id, p.segment1 value, null description from po_headers p where exists ( select null from po_distributions d where p.po_header_id=d.po_header_id and d.project_id is not null) order by p.segment1 AR أمر الشراء أمر الشراء المرتبط ببنود المصروفات D Bestellung Bestellung, die den Aufwandsposten zugeordnet ist E Pedido de Compra Pedido de compra relacionado con los conceptos de gasto F Commande Commande liée aux dépenses I Ordine di acquisto L'ordine di acquisto correlato alle voci di spesa JA 発注 支出項目に関連する発注 KO 구매 발주 비용 항목과 관련된 구매 발주 PTB Ordem de Compra Ordem de compra relacionada aos itens de dispêndio RU Заказ на приобретение Заказ на приобретение, связанный со статьями расхода S Inköpsorder Inköpsorder som är relaterad till utgiftsposterna TR Satınalma Siparişi Harcama kalemleriyle ilgili satınalma siparişi US Purchase Order Purchase order related to the expenditure items ZHS 采购订单 与支出项相关的采购订单 10 80 :p_transaction_type LOV Oracle PA_SRS_PAXSIADJ_TRX_TYPE Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PA_PAXSIADJ_TRAN_TYPE' order by meaning select meaning from pa_lookups where lookup_type = 'PA_PAXSIADJ_TRAN_TYPE' and lookup_code = 'ALL' Y AR نوع الحركة نوع تكلفة المورّد المطلوب تضمينه في التقرير D Transaktionsart Art der Lieferantenkosten, die in der Auswertung berücksichtigt werden soll E Tipo de Transacción Tipo de coste de proveedor que se va a incluir en el informe F Type de mouvement Type de coût fournisseur à inclure dans l'état I Tipo transazione Il tipo di costi fornitore da includere nel rapporto JA 取引タイプ レポートに含まれる仕入先原価のタイプ KO 거래 유형 보고서에 포함할 공급자 원가 유형 PTB Tipo de Transação Tipo de custo do fornecedor para incluir no relatório RU Тип транзакции Тип затрат поставщика для включения в отчет S Transaktionstyp Typen av leverantörskostnad som ska inkluderas i rapporten TR İşlem Tipi Rapora dahil edilecek tedarikçi maliyetinin tipi US Transaction Type Type of supplier cost to include in the report ZHS 事务处理类型 要包括在报表中的供应商成本类型 11 90 :p_from_gl_period LOV Oracle PA_SRS_GL_PERIODS Y Y select c.period_name id, c.period_name value, null description from pa_implementations a,gl_sets_of_books b,gl_periods c where a.set_of_books_id=b.set_of_books_id and b.period_set_name=c.period_set_name and b.accounted_period_type=c.period_type order by c.end_date AR من فترة الأستاذ العام بداية مدى فترة الأستاذ العام D Von RW-Periode Erste RW-Periode E De Período Contable Inicio del rango de períodos contables F Période GL - De Début de la fourchette de périodes GL I Periodo GL - Da Inizio dell'intervallo del periodo GL JA GL期間:自 GL期間範囲の開始 KO GL 기간: 부터 GL 기간 범위 시작 PTB Período GL - De Início da faixa de períodos GL RU Период ГК с Начало диапазона периодов ГК S Från redovisningsperiod Start på bokföringsperiodintervallet TR İlk GL Dönemi GL dönem aralığının başlangıcı US From GL Period Start of the GL period range ZHS 自 GL 期间 GL 期间范围的起始期间 12 100 :p_to_gl_period LOV Oracle PA_SRS_GL_PERIODS Y Y select c.period_name id, c.period_name value, null description from pa_implementations a,gl_sets_of_books b,gl_periods c where a.set_of_books_id=b.set_of_books_id and b.period_set_name=c.period_set_name and b.accounted_period_type=c.period_type order by c.end_date AR إلى فترة الأستاذ العام نهاية مدى فترة الأستاذ العام D Bis RW-Periode Letzte RW-Periode E A Período Contable Finalización del rango de períodos contables F Période GL - A Fin de la fourchette de périodes GL I Periodo GL - A Fine dell'intervallo del periodo GL JA GL期間:至 GL期間範囲の終了 KO GL 기간: 까지 GL 기간 범위 종료 PTB Período GL - Até Término da faixa de períodos GL RU Период ГК по Конец диапазона периодов ГК S Till redovisningsperiod Slut på bokföringsperiodintervallet TR Son GL Dönemi GL dönem aralığının sonu US To GL Period End of the GL period range ZHS 至 GL 期间 GL 期间范围的终止期间 13 110 :p_from_gl_account Char AR من حساب الأستاذ العام حساب البداية لمدى حساب الأستاذ العام D Von RW-Konto Erstes RW-Konto E De Cuenta Contable Cuenta inicial del rango de cuentas contables F Compte GL - De Compte de début de la fourchette de comptes GL I Conto GL - Da Conto iniziale dell'intervallo di conti GL JA GL勘定科目:自 GL勘定科目範囲の開始勘定科目 KO GL 계정: 부터 GL 계정 범위의 시작 계정 PTB Conta GL - De Conta inicial da faixa de contas GL RU Счет ГК с Начальный счет для диапазона счетов ГК S Från huvudbokskonto Startkonto för huvudbokskontointervallet TR İlk GL Hesabı GL hesap aralığının açılış hesabı US From GL Account Start account of the GL account range ZHS 自 GL 帐户 GL 帐户范围的起始帐户 14 120 :p_to_gl_account Char AR إلى حساب الأستاذ العام حساب النهاية لمدى حساب الأستاذ العام D Bis RW-Konto Letztes RW-Konto E A Cuenta Contable Cuenta final del rango de cuentas contables F Compte GL - A Compte de fin de la fourchette de comptes GL I Conto GL - A Conto finale dell'intervallo di conti GL JA GL勘定科目:至 GL勘定科目範囲の終了勘定科目 KO GL 계정: 까지 GL 계정 범위의 종료 계정 PTB Conta GL - Até Conta final da faixa de contas GL RU Счет ГК с 2 Конечный счет для диапазона счетов ГК S Till huvudbokskonto Slutkonto för huvudbokskontointervallet TR Son GL Hesabı GL hesap aralığının kapanış hesabı US To GL Account End account of the GL account range ZHS 至 GL 帐户 GL 帐户范围的终止帐户 15 130 :p_adjustment_type LOV Oracle PA_SRS_PAXSIADJ_ADJ_TYPE Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PA_PAXSIADJ_ADJ_TYPE' order by meaning select meaning from pa_lookups where lookup_type = 'PA_PAXSIADJ_ADJ_TYPE' and lookup_code = 'ALL' Y AR نوع التعديل يحدد ما إذا كان التقرير يتضمن كل بنود المصروفات أو مجموعة فرعية من بنود المصروفات المعدلة D Korrekturart Bestimmt, ob die Auswertung alle Aufwandsposten oder eine Gruppe korrigierter Aufwandsposten enthält E Tipo de Ajuste Determina si el informe incluye todos los conceptos de gasto o un subconjunto de conceptos de gasto ajustados. F Type d'ajustement Détermine si l'état inclut toutes les dépenses ou un sous-ensemble des dépenses ajustées I Tipo adeguamento Determina se il rapporto deve includere tutte le voci di spesa oppure una serie secondaria delle voci di spesa adeguate JA 修正タイプ レポートがすべての支出項目を含むか、 または修正された支出項目のサブセットを含むかを決定します KO 조정 유형 보고서에 비용 항목이 모두 포함될지 또는 조정된 비용 항목이 일부 포함될지 결정합니다. PTB Tipo de Ajuste Determina se o relatório inclui todos os itens de dispêndio ou um subconjunto dos itens de dispêndio ajustados RU Тип корректировки Атрибут для включения в отчет всех статей расхода либо только скорректированных S Justeringstyp Fastställer om rapporten innehåller alla utgiftsposter eller en delmängd av justerade utgiftsposter TR Düzeltme Tipi Raporun tüm harcama kalemlerini mi, yoksa düzeltilen harcama kalemlerinin bir alt kümesini mi içereceğini belirtir US Adjustment Type Determines if the report includes all expenditure items or a subset of adjusted expenditure items ZHS 调整类型 确定报表是包括所有支出项还是包括部分已调整的支出项 16 140 :p_sort_order LOV Oracle PA_SRS_PAXSIADJ_SORT_ORDER Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PA_PAXSIADJ_SORT_ORDER' order by meaning SELECT meaning FROM pa_lookups WHERE lookup_type = 'PA_PAXSIADJ_SORT_ORDER' AND lookup_code = 'AP' Y AR ترتيب الفرز ترتيب فرز وعرض بنود المصروفات D Sortierfolge Sortier- und Anzeigefolge der Aufwandsposten E Orden de Clasificación Clasificación y orden de presentación de los conceptos de gasto F Ordre de tri Ordre de tri et d'affichage des dépenses I Ordinamento Ordine di presentazione e visualizzazione delle voci di spesa JA ソート順 支出項目のソートおよび表示順 KO 정렬 순서 비용 항목의 정렬 및 표시 순서 PTB Ordem de Classificação Classificar e exibir ordem para os itens de dispêndio RU Порядок сортировки Порядок сортировки и вывода статей расхода S Sorteringsordning Sorterings- och visningsordning för utgiftsposterna TR Sıralama Düzeni Harcama kalemleri için sıralama ve görüntüleme düzeni US Sort Order Sort and display order for the expenditure items ZHS 排序顺序 支出项的排序和显示顺序