ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41DC40BF9D8ACFADE06362FB09059B24 SELECT /*+ push_pred() no_expand */ sr.reference_no, sr.header_id, sr.event_id, sr.legal_entity_id, sr.ledger_id, sr.operating_unit, sr.base_currency, sr.valuation_cost_type, sr.valuation_cost_type_id, sr.inventory_item_id, sr.organization_id, sr.item_revision, sr.transaction_source_type_id, sr.transaction_action_id, sr.transaction_type_id, sr.entity_code, sr.event_class, sr.event_type, sr.transaction_id, to_char(sr.transaction_date,'DD-MON-YYYY HH24:MI:SS') transaction_date, sr.transaction_quantity, sr.transaction_uom, gmf_subled_rep_pkg.get_org_name(sr.organization_id) org_name, gmf_subled_rep_pkg.get_item_desc(sr.inventory_item_id,sr.organization_id) item_desc, gmf_subled_rep_pkg.get_entity_code_desc(sr.entity_code) entity_code_desc, gmf_subled_rep_pkg.get_event_class_desc(sr.entity_code,sr.event_class) event_class_desc, gmf_subled_rep_pkg.get_event_type_desc(sr.entity_code,sr.event_class,sr.event_type) event_type_desc, sr.cm_adjustment_type, sr.cm_adjust_cost, sr.cm_reason_code, sr.cm_period_code, sr.cm_calendar_code, sr.cm_lot_number, sr.in_subinventory_code, sr.in_transfer_subinventory, sr.pm_batch_number, sr.pm_batch_status, to_char(sr.pm_actual_start_date,'DD-MON-YYYY HH24:MI:SS') pm_actual_start_date, to_char(sr.pm_actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS') pm_actual_cmplt_date, sr.pm_formula_no, sr.pm_formula_vers, sr.pm_routing_no, sr.pm_routing_vers, sr.pm_recipe_no, sr.pm_recipe_version, sr.pm_resources, sr.po_purchase_number, sr.po_supplier_name, sr.po_receipt_number, sr.po_receipt_line_number, sr.om_order_number, sr.om_customer_name, sr.om_line_number, sr.om_shipment_number FROM gmf_subledger_rep_v sr, gl_subr_sta gss WHERE sr.reference_no = NVL(:P_REFERENCE_NO,sr.reference_no) AND sr.legal_entity_id = :P_LEGAL_ENTITY_ID AND sr.ledger_id = :P_LEDGER_ID AND sr.valuation_cost_type_id = :P_COST_TYPE_ID AND sr.organization_id = NVL(:P_ORGANIZATION_ID,sr.organization_id) AND sr.reference_no = gss.reference_no AND gss.fiscal_year = :P_FISCAL_YEAR AND gss.period = :P_PERIOD AND sr.entity_code = NVL(:P_ENTITY_CODE,sr.entity_code) AND sr.event_class = NVL(:P_EVENT_CLASS, sr.event_class) AND sr.event_type = DECODE((SELECT INSTR(:P_EVENT_TYPE,'_ALL') FROM DUAL),0,:P_EVENT_TYPE,sr.event_type) AND sr.transaction_date >= TO_DATE(NVL(:p_start_dt , TO_CHAR(sr.transaction_date, 'DD-MON-YYYY HH24:MI:SS')),'DD-MON-YYYY HH24:MI:SS' ) AND sr.transaction_date <= TO_DATE(NVL(:p_end_dt , TO_CHAR(sr.transaction_date, 'DD-MON-YYYY HH24:MI:SS')),'DD-MON-YYYY HH24:MI:SS' ) AND ((NVL(:P_INCLUDE_ZERO_AMOUNT_LINES, 'N') = 'Y') OR EXISTS (SELECT 1 from gmf_xla_extract_lines el WHERE el.header_id = sr.header_id AND ( ((NVL(:P_INCLUDE_ZERO_AMOUNT_LINES, 'N') = 'N') AND (abs(el.base_amount) >= 0.005 OR abs(el.trans_amount) >= 0.005))))) ORDER BY sr.entity_code, sr.organization_id, DECODE(sr.entity_code,'INVENTORY', sr.TRANSACTION_ID, 'REVALUATION',sr.TRANSACTION_ID, 'ORDERMANAGEMENT',sr.OM_ORDER_NUMBER,sr.organization_id), DECODE(sr.entity_code,'PRODUCTION', sr.PM_BATCH_NUMBER, 'PURCHASING', sr.PO_PURCHASE_NUMBER,sr.entity_code) Y GMF GMFDSUR AR GMF تقرير الأستاذ الفرعي التفصيلي Imported from BI Publisher Description: تقرير الأستاذ الفرعي التفصيلي لماليات OPM Application: ماليات التصنيع التشغيلي Source: تقرير الأستاذ الفرعي التفصيلي Short Name: GMFDSUR DB package: D GMF Nebenbuch - Details Imported from BI Publisher Description: Detaillierte Nebenbuchauswertung für OPM Financials Application: Process Manufacturing Financials Source: Nebenbuch - Details Short Name: GMFDSUR DB package: E GMF Informe Libro Auxiliar Detallado Imported from BI Publisher Description: Informe Libro Auxiliar Detallado de Financials OPM Application: Process Manufacturing Financials Source: Informe Libro Auxiliar Detallado Short Name: GMFDSUR DB package: F GMF Etat détaillé de l'auxiliaire Imported from BI Publisher Description: Etat détaillé de l'auxiliaire d'OPM Financials Application: Process Manufacturing Financials Source: Etat détaillé de l'auxiliaire Short Name: GMFDSUR DB package: I GMF Rapporto sezionale dettagliato Imported from BI Publisher Description: Rapporto sezionale dettagliato per OPM Financials Application: Process Manufacturing Financials Source: Rapporto sezionale dettagliato Short Name: GMFDSUR DB package: JA GMF 詳細補助元帳レポート Imported from BI Publisher Description: OPM会計の詳細補助元帳レポート Application: Process Manufacturing Financials Source: 詳細補助元帳レポート Short Name: GMFDSUR DB package: KO GMF 상세한 보조원장 보고서 Imported from BI Publisher Description: OPM 회계에 대한 상세한 보조 원장 보고서 Application: Process Manufacturing Financials Source: 상세한 보조원장 보고서 Short Name: GMFDSUR DB package: PTB GMF Relatório do Sub-Razão Detalhado Imported from BI Publisher Description: Relatório Detalhado do Sub-Razão para OPM Financials Application: Process Manufacturing Financials Source: Relatório do Sub-Razão Detalhado Short Name: GMFDSUR DB package: RU GMF Подробный отчет по субкниге Imported from BI Publisher Description: Подробный отчет по субкниге для Финансов УПП Application: Финансы УНП Source: Подробный отчет по субкниге Short Name: GMFDSUR DB package: S GMF Detaljerad reskontrarapport Imported from BI Publisher Description: Detaljerad reskontrarapport för OPM Financials Application: Processtillverkning: Ekonomi Source: Detaljerad reskontrarapport Short Name: GMFDSUR DB package: TR GMF Detaylı Cari Hesap Raporu Imported from BI Publisher Description: OPM Finansal Yönetim için Detaylı Cari Hesap Raporu Application: Üretim Prosesi Finansal Yönetim Source: Detaylı Cari Hesap Raporu Short Name: GMFDSUR DB package: US GMF Detailed Subledger Imported from BI Publisher Description: Detailed Subledger Report for OPM Financials Application: Process Manufacturing Financials Source: Detailed Subledger Report Short Name: GMFDSUR DB package: ZHS GMF 明细子分类帐报表 Imported from BI Publisher Description: OPM 财务 的明细子分类帐报表 Application: OPM 财务管理系统 Source: 明细子分类帐报表 Short Name: GMFDSUR DB package: BI Publisher 1=1 :p_cost_type :p_end_date :p_entity_code :p_event_class :p_event_type :p_fiscal_year :p_ledger :p_legal_entity :p_period :p_reference_no :p_start_date :p_where_clause 1 10 :p_reference_no LOV Oracle GMF_SRS_REFERENCE_NO Y select eh.reference_no id, eh.reference_no value, null description from gmf_xla_extract_headers eh where eh.header_id=( select min (b.header_id) from gmf_xla_extract_headers b where b.reference_no=eh.reference_no) order by eh.reference_no desc US Reference No Reference No 2 20 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITIES_VS Y select gfp.legal_entity_id id, glp.legal_entity_name value, null description from gmf_legal_entities glp,gmf_fiscal_policies gfp where glp.legal_entity_id=gfp.legal_entity_id order by glp.legal_entity_name SELECT legal_entity_name VALUE,NULL MEANING FROM GL_SUBR_STA WHERE REFERENCE_NO =:$flex$.reference_no Y US Legal Entity Legal Entity 3 30 :p_ledger_id LOV Oracle GMF_SRS_LEDGERS Y select led.ledger_id id, led.name value, null description from gmf_ledger_valuation_methods glvm,gl_ledgers led,cm_mthd_mst mthd where glvm.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and led.ledger_id=glvm.ledger_id and mthd.cost_type_id=glvm.cost_type_id order by led.name,mthd.cost_mthd_code SELECT name VALUE,short_name MEANING FROM GL_SUBR_STA gss, gl_ledgers gl WHERE gss.ledger_id = gl.ledger_id AND gss.reference_no =:$flex$.reference_no Y US Ledger Ledger 4 40 :p_cost_type_id LOV Oracle GMF_COST_TYPES Y select mthd.cost_type_id id, mthd.cost_mthd_code value, null description from gmf_ledger_valuation_methods glvm,cm_mthd_mst mthd,gem_lookups lk where glvm.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and glvm.ledger_id=:$flex$.gmf_srs_ledgers and mthd.cost_type_id=glvm.cost_type_id and lk.lookup_type='GMF_COST_METHOD' and mthd.cost_type=lk.lookup_code order by mthd.cost_mthd_code SELECT cost_mthd_code VALUE, NULL MEANING FROM gl_subr_sta WHERE reference_no =:$flex$.reference_no Y US Cost Type Cost Type 5 50 :p_fiscal_year LOV Oracle GMF_SRS_GL_FISCAL_YEAR Y select glp.period_year id, glp.period_year value, gps.description description from gl_periods glp,gl_period_sets gps,gl_sets_of_books gsb,gmf_ledger_valuation_methods glvm where glvm.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and glvm.ledger_id=:$flex$.gmf_srs_ledgers and glvm.ledger_id=gsb.set_of_books_id and gsb.period_set_name=glp.period_set_name and glp.period_set_name=gps.period_set_name and gsb.accounted_period_type=glp.period_type and glp.period_num= (select min (p2.period_num) from gl_periods p2 where p2.period_set_name=gsb.period_set_name and p2.period_type=gsb.accounted_period_type and p2.period_year=glp.period_year) order by glp.period_year desc SELECT fiscal_year VALUE, NULL MEANING FROM gl_subr_sta WHERE reference_no =:$flex$.reference_no Y US Fiscal Year Fiscal Year 6 60 :p_period LOV Oracle GMF_SRS_GL_PERIODS Y select glp.period_num id, glp.period_num value, glp.period_name description from gl_periods glp,gl_period_statuses sts,gl_sets_of_books sob where sob.set_of_books_id=:$flex$.gmf_srs_ledgers and glp.period_set_name=sob.period_set_name and glp.period_type=sob.accounted_period_type and glp.period_year=:$flex$.gmf_srs_gl_fiscal_year and glp.period_num=sts.period_num and glp.period_year=sts.period_year and sts.set_of_books_id=sob.set_of_books_id and sts.application_id=101 order by glp.period_num SELECT period VALUE, NULL MEANING FROM gl_subr_sta WHERE reference_no =:$flex$.reference_no Y US Period Period 7 70 :p_organization_id LOV Oracle GMF_SRS_ORGANIZATION_CODES Y select organization_id id, organization_code value, organization_name description from gmf_organization_definitions where legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and ledger_id=:$flex$.gmf_srs_ledgers order by organization_code US Organization Code Organization Code 8 80 :p_start_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(PERIOD_START_DATE) VALUE,NULL MEANING FROM GL_SUBR_STA WHERE REFERENCE_NO =:$flex$.reference_no US Start Date Start Date 9 90 :p_end_date DateTime SELECT FND_DATE.DATE_TO_CHARDT(PERIOD_END_DATE) VALUE,NULL MEANING FROM GL_SUBR_STA WHERE REFERENCE_NO =:$flex$.reference_no US End Date End Date 10 100 :p_entity_code LOV Oracle GMF_SRS_SLA_ENTITY_CODES Y select entity_code id, name value, null description from xla_entity_types_vl where entity_code not in ('MANUAL','THIRD_PARTY_MERGE') and (application_id=555) and enabled_flag='Y' order by entity_code US Entity Code Entity Code 11 110 :p_event_class LOV Oracle GMF_SRS_SLA_EVENT_CLASSES Y select event_class_code id, name value, null description from xla_event_classes_vl where application_id=555 and entity_code=:$flex$.gmf_srs_sla_entity_codes and enabled_flag='Y' order by name US Event Class Event Class 12 120 :p_event_type LOV Oracle GMF_SRS_SLA_EVENT_TYPES Y select event_type_code id, name value, null description from xla_event_types_vl where application_id=555 and entity_code=:$flex$.gmf_srs_sla_entity_codes and event_class_code=:$flex$.gmf_srs_sla_event_classes and enabled_flag='Y' order by name US Event Type Event Type 13 130 :p_include_zero_amount_lines LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' US Include Zero Amount lines Flag Include Zero Amt lines Flag :$flex$.gmf_srs_gl_fiscal_year Fiscal Year Period :$flex$.gmf_srs_ledgers Ledger Cost Type :$flex$.gmf_srs_ledgers Ledger Fiscal Year :$flex$.gmf_srs_ledgers Ledger Organization Code :$flex$.gmf_srs_ledgers Ledger Period :$flex$.gmf_srs_legal_entities_vs Legal Entity Cost Type :$flex$.gmf_srs_legal_entities_vs Legal Entity Fiscal Year :$flex$.gmf_srs_legal_entities_vs Legal Entity Ledger :$flex$.gmf_srs_legal_entities_vs Legal Entity Organization Code :$flex$.gmf_srs_sla_entity_codes Entity Code Event Class :$flex$.gmf_srs_sla_entity_codes Entity Code Event Type :$flex$.gmf_srs_sla_event_classes Event Class Event Type :$flex$.reference_no Reference No Cost Type :$flex$.reference_no Reference No End Date :$flex$.reference_no Reference No Fiscal Year :$flex$.reference_no Reference No Ledger :$flex$.reference_no Reference No Legal Entity :$flex$.reference_no Reference No Period :$flex$.reference_no Reference No Start Date