ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B151A9E05362FB09050512 SELECT null C_M_ACCT_FLEX , null C_D_ACCT_FLEX , WTA2.TRANSACTION_DATE Txn_Date , BR.RESOURCE_CODE Resource1 , ML1.MEANING Txn_Type , WT.TRANSACTION_TYPE Txn_Type_Number , WE.WIP_ENTITY_NAME Job_Assembly , WT.OPERATION_SEQ_NUM Op_Seq , BR.UNIT_OF_MEASURE UOM , round(WTA2.PRIMARY_QUANTITY,:P_qty_precision) Quantity , round(WTA2.RATE_OR_AMOUNT,:C_Curr_Precision) Rate_or_Amount , round(WTA2.BASE_TRANSACTION_VALUE,:C_Curr_Precision) Extended_Cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_m_acct_sort', 'SQLGL', 'GL#', GCC1.CHART_OF_ACCOUNTS_ID, NULL, GCC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_M_ACCT_SORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_m_acct_field', 'SQLGL', 'GL#', GCC1.CHART_OF_ACCOUNTS_ID, NULL, GCC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_M_ACCT_FIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_ACCT_DESCRIP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_d_acct_sort', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_D_ACCT_SORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_d_acct_field', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_D_ACCT_FIELD FROM WIP_ENTITIES WE , MFG_LOOKUPS ML1 , BOM_RESOURCES BR , GL_CODE_COMBINATIONS GCC1 , GL_CODE_COMBINATIONS GCC2 , WIP_TRANSACTION_ACCOUNTS WTA1 , WIP_TRANSACTION_ACCOUNTS WTA2 , WIP_TRANSACTIONS WT WHERE WT.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Dates AND WT.TRANSACTION_ID = WTA2.TRANSACTION_ID AND WTA2.TRANSACTION_ID = WTA1.TRANSACTION_ID AND WTA2.CONTRA_SET_ID = WTA1.CONTRA_SET_ID AND WTA2.REFERENCE_ACCOUNT <> WTA1.REFERENCE_ACCOUNT AND WTA2.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WTA1.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WTA2.ACCOUNTING_LINE_TYPE <> 15 AND WTA1.ACCOUNTING_LINE_TYPE <> 15 AND GCC1.CODE_COMBINATION_ID = WTA1.REFERENCE_ACCOUNT --&C_Limit_Accounts and &P_ACCT_WHERE AND GCC2.CODE_COMBINATION_ID = WTA2.REFERENCE_ACCOUNT AND ML1.LOOKUP_TYPE='WIP_TRANSACTION_TYPE_SHORT' AND ML1.LOOKUP_CODE=WT.TRANSACTION_TYPE AND WE.WIP_ENTITY_ID = WTA2.WIP_ENTITY_ID AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID AND BR.RESOURCE_ID(+) = WTA2.RESOURCE_ID AND BR.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID GROUP BY null , null , WTA2.TRANSACTION_DATE , ML1.MEANING , WT.TRANSACTION_TYPE , WE.WIP_ENTITY_NAME , WT.OPERATION_SEQ_NUM , BR.RESOURCE_CODE , BR.UNIT_OF_MEASURE , WT.CREATION_DATE , WTA2.TRANSACTION_ID , round(WTA2.PRIMARY_QUANTITY,:P_qty_precision) , round(WTA2.RATE_OR_AMOUNT,:C_Curr_Precision) , round(WTA2.BASE_TRANSACTION_VALUE,:C_Curr_Precision) , WTA2.ROWID ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_m_acct_sort', 'SQLGL', 'GL#', GCC1.CHART_OF_ACCOUNTS_ID, NULL, GCC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_m_acct_field', 'SQLGL', 'GL#', GCC1.CHART_OF_ACCOUNTS_ID, NULL, GCC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_d_acct_sort', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_d_acct_field', 'SQLGL', 'GL#', GCC2.CHART_OF_ACCOUNTS_ID, NULL, GCC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') order by C_M_ACCT_SORT,C_D_ACCT_SORT Y WIP WIPUTOAC_XML AR WIP تقرير حساب مقاصة ما تحت التنفيذ (بتنسيق XML) Imported from BI Publisher Description: تقرير حساب مقاصة ما تحت التنفيذ Application: العمل في الإنجاز Source: تقرير حساب مقاصة ما تحت التنفيذ (بتنسيق XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG D WIP Fertigung - Verrechnungskonten Imported from BI Publisher Description: Fertigung - Verrechnungskonten Application: Fertigung Source: Fertigung - Verrechnungskonten (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG E WIP Cuenta de Compensación de WIP Imported from BI Publisher Description: Informe de cuenta de compensación de obra en curso Application: Work in Process Source: Cuenta de Compensación de WIP (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG F WIP Etat Comptes de contrepartie des en-cours Imported from BI Publisher Description: Etat Comptes de contrepartie des en-cours Application: Work In Process Source: Etat Comptes de contrepartie des en-cours (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG I WIP Rapporto Conto di contropartita WIP Imported from BI Publisher Description: Rapporto Conto di contropartita WIP Application: Work in Process Source: Rapporto Conto di contropartita WIP (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG JA WIP WIP相殺勘定レポート Imported from BI Publisher Description: WIP相殺勘定レポート Application: Work in Process Source: WIP相殺勘定レポート(XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG KO WIP 상계 계정 보고서 Imported from BI Publisher Description: WIP 상계 계정 보고서 Application: Work in Process Source: WIP 상계 계정 보고서(XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG PTB WIP Relatório de Conta de Contrapartida do WIP Imported from BI Publisher Description: Rel. Conta Contrapartida WIP Application: Work in Process Source: Relatório de Conta de Contrapartida do WIP (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG RU WIP Отчет о счетах компенсаций НзП Imported from BI Publisher Description: Отчет о счетах компенсаций НзП Application: Незавершенное производство Source: Отчет о счетах компенсаций НзП (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG S WIP Motkonteringar - rapport Imported from BI Publisher Description: PIA: Motkonteringar - rapport Application: Work in Process Source: PIA: Motkonteringar - rapport (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG TR WIP Denkleştirme Hesap Raporu Imported from BI Publisher Description: WIP Denkleştiren Hesap Raporu Application: Üretim İzleme Source: WIP Denkleştirme Hesap Raporu (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG US WIP Offsetting Account Imported from BI Publisher Description: WIP Offsetting Account Report Application: Work in Process Source: WIP Offsetting Account Report (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG ZHS WIP 抵销帐户报表 Imported from BI Publisher Description: WIP 抵销帐户报表 Application: 在制品管理系统 Source: WIP 抵销帐户报表 (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG BI Publisher &c_limit_accounts &c_limit_dates &p_acct_where :c_curr_precision :p_acct_where :p_conc_request_id :p_d_acct_flex :p_debug :p_from_account :p_from_date :p_m_acct_flex :p_organization_id :p_qty_precision :p_struct_num :p_to_account :p_to_date 1 -40 :p_struct_num Number SELECT CHART_OF_ACCOUNTS_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR رقم هيكل مرن رقم هيكل مرن D FlexFeld-Struktur-Nummer FlexFeld-Struktur-Nummer E Número de Tipo de Estructura Número de Tipo de Estructura F Numéro structure flexible Numéro structure flexible I Numero struttura flexfield Numero struttura flexfield JA フレックス体系番号 フレックス体系番号 KO 가변 구조 번호 가변 구조 번호 PTB Número da Estrutura de Flexfield Número da Estrutura de Flexfield RU Номер структуры ГП Номер структуры ГП S Flexstrukturnummer Flexstrukturnummer TR Esnek Yapı Numarası Esnek Yapı Numarası US Flex Structure Number Flex Structure Number ZHS 弹性结构编号 弹性结构编号 2 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Org_id معرف التنظيم D Org_id Organisationskennung E Org_id Id Organización F Org_id ID organisation I Org_id Id dell'organizzazione JA Org_id 組織ID KO Org_id 조직 ID PTB Org_id Id da Organização RU Org_id Идент. организ. S Org_id Organisations-id TR Org_id Organizasyon No US Org_id Organization Id ZHS Org_id 组织标识 3 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad precisión de cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점이하 자리수 수량 소수점자리 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision kvantitetsprecision TR Miktar Duyarlılığı miktar duyarlılığı US Quantity Precision quantity precision ZHS 数量精确度 数量精确度 4 10 :p_from_date Date AR التواريخ من التواريخ من D Datum von Datum von E De Fecha de fecha F Dates - Du Dates - Du I Date - Da Date - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Datas - De Datas - De RU Даты с даты с S Från datum Datum från TR Tarihler, İlk tarihler: ilk US Dates From dates from ZHS 日期自 起始日期 5 20 :p_to_date Date AR إلى التواريخ إلى D Bis Bis E A a fecha F A Dates - Au I A Date - A JA 至 日付:至 KO 까지 일자: 까지 PTB Até Datas - De RU По даты по S Till datum till TR Son Başlangıç Tarihi US To dates to ZHS 至 终止日期 6 30 :p_from_account Char AR حسابات من الحسابات من D Von Konto Von Konto E De Cuenta de cuenta F Comptes - De Comptes - De I Conti - Da Conti - Da JA 勘定科目:自 勘定科目:自 KO 계정: From 계정: 부터 PTB Contas - De Contas - De RU Счета с счета с S Från konton konton från TR Hesaplar, İlk hesaplar: ilk US Accounts From accounts from ZHS 帐户自 帐户自 7 40 :p_to_account Char AR إلى 2 الحسابات إلى D Bis 2 Bis Konto E A 2 a cuenta F A 2 Comptes - A I A 2 Conti - A JA 至 2 勘定科目:至 KO 까지 2 계정: 까지 PTB Até 2 Contas - até RU По 2 счета по S Till 2 konton till TR Son 2 hesaplar: son US To 2 accounts to ZHS 至 2 帐户至