ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704A51A9E05362FB09050512Y SELECT aeh.accounting_date GL_DATE ,ENT.TRANSACTION_NUMBER TRANSACTION_NUMBER ,fns.name DOCUMENT_SEQUENCE_NAME ,aeh.doc_sequence_value DOCUMENT_SEQUENCE_NUMBER ,xlk.meaning ACCOUNTING_CLASS_NAME ,ael.description LINE_DESCRIPTION ,gcck.concatenated_segments ACCOUNTING_CODE_COMBINATION --,xla_report_utility_pkg.get_ccid_desc(gll.chart_of_accounts_id,ael.code_combination_id) CODE_COMBINATION_DESCRIPTION ,aeh.entity_id ENTITY_ID ,aeh.event_id EVENT_ID ,aeh.ae_header_id HEADER_ID ,aeh.event_type_code EVENT_TYPE_CODE ,aeh.gl_transfer_status_code GL_TRANSFER_STATUS ,DECODE(gl_transfer_status_code,'Y',&G_POSTING_FLAG,'') POSTING_STATUS ,aeh.accounting_entry_status_code ACCOUNTING_ENTRY_STATUS ,aeh.balance_type_code BALANCE_TYPE_CODE ,ael.ae_line_num LINE_NUMBER ,ael.code_combination_id CL_CODE_COMBINATION_ID ,ael.accounted_dr ACCOUNTED_DR ,ael.accounted_cr ACCOUNTED_CR ,NVL(ael.accounted_dr,0) M_ACCOUNTED_DR -- for calculating running balace these columns being used. ,NVL(ael.accounted_cr,0) M_ACCOUNTED_CR ,ael.entered_dr ENTERED_DR ,ael.entered_cr ENTERED_CR ,ael.currency_code ENTERED_CURRENCY ,ael.control_balance_flag CONTROL_BALANCE_FLAG ,ael.displayed_line_number DISPLAYED_LINE_NUMBER ,ent.entity_code ENTITY_CODE ,ent.source_id_int_1 SOUCE_ID_INT_1 ,ent.source_id_int_2 SOUCE_ID_INT_2 ,ent.source_id_int_3 SOUCE_ID_INT_3 ,ent.source_id_int_4 SOUCE_ID_INT_4 ,&P_ALIAS_BALANCING_SEGMENT BALANCING_SEGMENT ,&P_ALIAS_ACCOUNT_SEGMENT NATURAL_ACCOUNT_SEGMENT ,fvl.description NATURAL_ACCOUNT_SEGMENT_DESC ,CASE aeh.application_id WHEN 200 THEN CASE WHEN ent.entity_code = 'AP_INVOICES' THEN (select LU.displayed_field FROM AP_LOOKUP_CODES LU ,AP_INVOICES_ALL I WHERE LU.lookup_type = 'INVOICE TYPE' AND LU.lookup_code = I.invoice_type_lookup_code AND I.invoice_id = ent.source_id_int_1) WHEN ent.entity_code = 'AP_PAYMENTS' THEN (SELECT LU.displayed_field FROM AP_LOOKUP_CODES LU ,AP_CHECKS_ALL C WHERE LU.lookup_type = 'PAYMENT METHOD' AND LU.lookup_code = C.payment_method_lookup_code AND C.check_id = ent.source_id_int_1) ELSE (SELECT name from xla_event_types_vl WHERE application_id = 200 AND entity_code = 'MANUAL') END WHEN 222 THEN CASE WHEN ent.entity_code = 'ADJUSTMENTS' THEN (select ttlkp.meaning from ar_adjustments_all adj ,fnd_lookups ttlkp WHERE ttlkp.lookup_type = 'JGZZ_SLR_TRANS_TYPE' AND ((adj.adjustment_type= 'E' and ttlkp.lookup_code = 'ENDORSEMENT') or (adj.adjustment_type <> 'E' and ttlkp.lookup_code = 'ADJUSTMENT')) AND adj.adjustment_id = ent.source_id_int_1) WHEN ent.entity_code = 'TRANSACTIONS' THEN (select ttlkp.meaning from ra_customer_trx_all ct ,ra_cust_trx_types_all ctt ,fnd_lookups ttlkp WHERE ttlkp.lookup_code = ctt.type AND ttlkp.lookup_type = 'JGZZ_SLR_TRANS_TYPE' AND ctt.cust_trx_type_id = ct.cust_trx_type_id AND ct.org_id = ctt.org_id AND ct.customer_trx_id = ent.source_id_int_1) WHEN ent.entity_code = 'RECEIPTS' THEN (select ttlkp.meaning from ar_cash_receipts_all cr ,fnd_lookups ttlkp WHERE ttlkp.lookup_code = decode(cr.type, 'MISC', 'MISCELLANEOUS', 'TRADE_RECEIPTS') AND ttlkp.lookup_type = 'JGZZ_SLR_TRANS_TYPE' AND cr.cash_receipt_id = ent.source_id_int_1) WHEN ent.entity_code = 'BILLS_RECEIVABLE' THEN (select ttlkp.meaning from ra_customer_trx_all ct ,ra_cust_trx_types_all ctt ,fnd_lookups ttlkp WHERE ttlkp.lookup_code = ctt.type AND ttlkp.lookup_type = 'JGZZ_SLR_TRANS_TYPE' AND ctt.cust_trx_type_id = ct.cust_trx_type_id AND ct.customer_trx_id = ent.source_id_int_1) ELSE (select name from xla_event_types_vl WHERE application_id = 200 AND entity_code = 'MANUAL') END END transaction_type FROM xla_transaction_entities_upg ent ,xla_ae_headers aeh ,xla_ae_lines ael ,fnd_document_sequences fns ,xla_lookups xlk ,gl_ledgers gll ,gl_code_combinations_kfv gcck ,fnd_id_flex_segments fsg ,fnd_flex_values_vl fvl ,fnd_segment_attribute_values fsav2 WHERE ael.application_id = aeh.application_id AND ael.ae_header_id = aeh.ae_header_id AND xlk.lookup_type = 'XLA_ACCOUNTING_CLASS' AND xlk.lookup_code = ael.accounting_class_code AND ent.application_id = aeh.application_id AND ent.entity_id = aeh.entity_id AND fns.application_id(+) = aeh.application_id AND fns.doc_sequence_id(+) = AEH.DOC_SEQUENCE_ID AND gll.ledger_id = aeh.ledger_id AND gcck.code_combination_id = ael.code_combination_id AND gcck.chart_of_accounts_id = gll.chart_of_accounts_id AND fsav2.application_id = 101 AND fsav2.id_flex_code = 'GL#' AND fsav2.id_flex_num = gll.chart_of_accounts_id AND fsav2.attribute_value = 'Y' AND fsav2.segment_attribute_type = 'GL_ACCOUNT' AND fsg.application_id = 101 AND fsg.id_flex_code = 'GL#' AND fsg.id_flex_num = gll.chart_of_accounts_id AND fvl.flex_value = &P_ALIAS_ACCOUNT_SEGMENT AND fsg.application_column_name = fsav2.application_column_name AND fsg.flex_value_set_id = fvl.flex_value_set_id AND AEL.LEDGER_ID = AEH.LEDGER_ID AND AEH.LEDGER_ID = :LEDGER_ID AND AEH.APPLICATION_ID = :CCID_APPLICATION_ID AND AEL.PARTY_ID = :PARTY_ID AND NVL(AEL.PARTY_SITE_ID,-999) = :PARTY_SITE_ID AND AEL.PARTY_TYPE_CODE = :PARTY_TYPE_CODE AND AEH.ACCOUNTING_DATE BETWEEN :P_GL_DATE_FROM AND :P_GL_DATE_TO AND ael.code_combination_id <> :code_combination_id AND (aeh.gl_transfer_status_code = :P_GL_TRANSFER_STATUS OR :P_GL_TRANSFER_STATUS IS NULL OR :P_GL_TRANSFER_STATUS='A') AND EXISTS ( SELECT 1 FROM XLA_AE_LINES AEL1 WHERE AEL1.AE_HEADER_ID = AEH.AE_HEADER_ID AND AEL1.APPLICATION_ID = AEH.APPLICATION_ID --AND AEL1.CONTROL_BALANCE_FLAG = 'Y' AND AEL1.CODE_COMBINATION_ID = :CODE_COMBINATION_ID) AND ( AEH.DOC_SEQUENCE_ID = :P_DOCUMENT_SEQUENCE_NAME OR :P_DOCUMENT_SEQUENCE_NAME IS NULL) AND NVL(AEH.DOC_SEQUENCE_VALUE,-1) BETWEEN NVL(:P_DOC_SEQUENCE_NUMBER_FROM,NVL(AEH.DOC_SEQUENCE_VALUE,-1)) AND NVL(:P_DOC_SEQUENCE_NUMBER_TO,NVL(AEH.DOC_SEQUENCE_VALUE,-1)) AND ( :P_DIST_DR_CR IS NULL OR (( :P_DIST_DR_CR = 'DEBIT' AND AEL.ACCOUNTED_DR BETWEEN NVL(:P_DIST_AMT_FROM,AEL.ACCOUNTED_DR) AND NVL(:P_DIST_AMT_TO,AEL.ACCOUNTED_DR)) OR ( :P_DIST_DR_CR = 'CREDIT' AND AEL.ACCOUNTED_CR BETWEEN NVL(:P_DIST_AMT_FROM,AEL.ACCOUNTED_CR) AND NVL(:P_DIST_AMT_TO,AEL.ACCOUNTED_CR)) ) ) &P_DIST_ACCOUNT_FF_RANGE_FILTER &P_OTHER_FILTER ORDER BY aeh.accounting_date ,aeh.doc_sequence_value ,ent.transaction_number JA JAJPTPBC JA JA パーティ別詳細残高(相手勘定明細)レポート Imported from BI Publisher Application: Asia/Pacific Localizations Source: パーティ別詳細残高(相手勘定明細)レポート Short Name: JAJPTPBC DB package: JA_JP_TP_BAL_CTRL_RPT_PKG KO JA 상대 계정 보고서가 있는 제3자 상세 시산표 Imported from BI Publisher Application: Asia/Pacific Localizations Source: 상대 계정 보고서가 있는 제3자 상세 시산표 Short Name: JAJPTPBC DB package: JA_JP_TP_BAL_CTRL_RPT_PKG US JA Third Party Detail Trial Balance with Contra Accounts Imported from BI Publisher Application: Asia/Pacific Localizations Source: Third Party Detail Trial Balance with Contra Accounts Report Short Name: JAJPTPBC DB package: JA_JP_TP_BAL_CTRL_RPT_PKG ZHS JA 具有抵销账户的第三方明细试算表报表 Imported from BI Publisher Application: 亚太地区本地化 Source: 具有抵销账户的第三方明细试算表报表 Short Name: JAJPTPBC DB package: JA_JP_TP_BAL_CTRL_RPT_PKG BI Publisher &g_posting_flag &p_alias_account_segment &p_alias_balancing_segment &p_dist_account_ff_range_filter &p_other_filter :ccid_application_id :code_combination_id :g_posting_flag :ledger_id :p_accounting_flexfield_from :p_accounting_flexfield_to :p_alias_account_segment :p_alias_balancing_segment :p_coa_id :p_commercial_query :p_dist_account_ff_range_filter :p_dist_acct_flexfield_from :p_dist_acct_flexfield_to :p_dist_amt_from :p_dist_amt_to :p_dist_dr_cr :p_doc_sequence_number_from :p_doc_sequence_number_to :p_document_sequence_name :p_document_sequence_value :p_end_date :p_end_period_num :p_gl_date_from :p_gl_date_to :p_gl_transfer_status :p_gl_transfer_value :p_include_draft_activity :p_include_draft_activity_flag :p_include_le_info_flag :p_include_legal_entity :p_je_source :p_je_source_name :p_lang :p_ledger :p_ledger_id :p_legal_ent_col :p_legal_ent_from :p_legal_ent_join :p_legal_entity :p_legal_entity_id :p_other_filter :p_party_col :p_party_join :p_party_tab :p_party_type :p_period_from :p_period_to :p_qualifier_segment :p_resp_application_id :p_seg_desc_from :p_seg_desc_join :p_start_date :p_start_period_num :p_third_party_name_from :p_third_party_name_to :p_third_party_number_from :p_third_party_number_to :p_third_party_site_name_from :p_third_party_site_name_to :p_trx_identifiers :p_vat_registration_query :party_id :party_site_id :party_type_code 1 -80 :p_resp_application_id Char fnd_profile.value('RESP_APPL_ID') JA 職責アプリケーションID 職責アプリケーションID KO 권한 애플리케이션 ID 권한 애플리케이션 ID US Responsibility Application ID Responsibility Application ID ZHS 责任应用标识 责任应用标识 2 -70 :p_ledger Char SELECT :$flex$.ledger.VALUE FROM DUAL JA 元帳名 元帳名 KO 원장명 원장명 US Ledger Name Ledger Name ZHS 分类帐名称 分类帐名称 3 -60 :p_legal_entity Char SELECT :$flex$.legal_entity.VALUE FROM DUAL JA 法的エンティティ名 法的エンティティ名 KO 법인명 법인명 US Legal Entity Name Legal Entity Name ZHS 法人主体名称 法人主体名称 4 -50 :p_coa_id LOV Oracle JGSLA_CHART_OF_ACCOUNTS Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id=:$flex$.jgsla_jelines_ledgers order by value,description SELECT chart_of_accounts_id FROM gl_ledgers WHERE ledger_id = :$flex$.ledger JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID US Chart of Accounts ID Chart of Accounts ID ZHS 科目表标识 科目表标识 5 -40 :p_show_adj_period 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 Y JA XLA_SRS_YES_NO 調整期間の表示 KO XLA_SRS_YES_NO 조정 기간 표시 US XLA_SRS_YES_NO Show Adjust Periods ZHS XLA_SRS_YES_NO 显示调整期 6 -30 :p_document_sequence_value Char SELECT :$flex$.document_sequence_name.VALUE FROM DUAL JA 文書連番値 文書連番値 KO 문서 순번 값 문서 순번 값 US Document Sequence Value Document Sequence Value ZHS 单据序号值 单据序号值 7 -20 :p_gl_transfer_value Char SELECT :$flex$.gl_transfer_status.VALUE FROM DUAL JA GL転送値 GL転送値 KO GL 이전 값 GL 이전 값 US GL Transfer Value GL Transfer Value ZHS GL 传送值 GL 传送值 8 10 :p_ledger_id LOV Oracle JGSLA_JELINES_LEDGERS Y select ledger_id id, name value, description description from gl_ledgers a where a.object_type_code='L' and ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or exists (select 1 from gl_access_set_ledgers b where b.ledger_id=a.ledger_id and b.access_set_id in (decode (fnd_global.resp_appl_id ,101 ,null ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ,null ) ) ,decode (fnd_global.resp_appl_id ,101 ,fnd_profile.value('GL_ACCESS_SET_ID') ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('GL_ACCESS_SET_ID') ,b.access_set_id) ) ) ) ) order by value,description Y JA 元帳 元帳ID KO 원장 원장 ID US Ledger Ledger ID ZHS 分类帐 分类帐标识 9 20 :p_legal_entity_id LOV Oracle JGSLA_LEGAL_ENTITIES Y select gle.legal_entity_id id, xfi.name value, null description from gl_ledger_le_v gle,xle_firstparty_information_v xfi where gle.ledger_id=:$flex$.jgsla_jelines_ledgers and gle.legal_entity_id=xfi.legal_entity_id order by xfi.name Y JA 法的エンティティ 法的エンティティID KO 법인 법인 ID US Legal Entity Legal Entity ID ZHS 法人主体 法人主体标识 10 30 :p_accounting_flexfield_from Char JA 会計フレックスフィールド: 自 会計フレックスフィールド: 自 KO 계정 가변필드: 부터 계정 가변필드: 부터 US Accounting Flexfield From Accounting Flexfield From ZHS 会计科目弹性域自 会计科目弹性域自 11 40 :p_accounting_flexfield_to Char JA 会計フレックスフィールド: 至 会計フレックスフィールド: 至 KO 계정 가변필드: 까지 계정 가변필드: 까지 US Accounting Flexfield To Accounting Flexfield To ZHS 会计科目弹性域至 会计科目弹性域至 12 50 :p_period_from LOV Oracle JGSLA_JELINES_PERIOD_FROM_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where gl.ledger_id=:$flex$.jgsla_jelines_ledgers and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or(nvl(:$flex$.xla_srs_yes_no,'N')='Y')) order by glp.period_year desc,glp.period_num desc Y JA 期間: 自 期間: 自 KO 기간: 부터 기간: 부터 US Period From Period From ZHS 起始期间 起始期间 13 60 :p_period_to LOV Oracle JGSLA_JELINES_PERIOD_TO_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or (nvl(:$flex$.xla_srs_yes_no,'N')='Y')) and gl.ledger_id=:$flex$.jgsla_jelines_ledgers and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.period_year= (select glp2.period_year from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jgsla_jelines_period_from_adj ) and glp.period_num>= (select glp2.period_num from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jgsla_jelines_period_from_adj ) order by glp.period_year desc,glp.period_num desc SELECT :$flex$.period_from FROM DUAL Y JA 期間: 至 期間: 至 KO 기간: 까지 기간: 까지 US Period To Period To ZHS 终止期间 终止期间 14 70 :p_gl_date_from Date SELECT to_char(glp.start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_from Y JA GL記帳日: 自 GL記帳日: 自 KO GL 일자: 부터 GL 일자: 부터 US GL Date From GL Date From ZHS GL 起始日期 GL 起始日期 15 80 :p_gl_date_to Date SELECT to_char(glp.end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_to Y JA GL記帳日: 至 GL記帳日: 至 KO GL 일자: 까지 GL 일자: 까지 US GL Date To GL Date To ZHS GL 终止日期 GL 终止日期 16 90 :p_je_source_name LOV Oracle JGSLA_SRS_JE_SOURCES_ALL Y select je_source_name id, user_je_source_name value, null description from (select user_je_source_name,je_source_name from gl_je_sources union all select meaning,'#ALL#' from xla_lookups where lookup_type='XLA_ALL') a where exists (select 1 from xla_subledgers b where b.je_source_name= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,a.je_source_name ,b.je_source_name ) and b.application_id= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,fnd_global.resp_appl_id ,b.application_id ) ) or (fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE')='Y' and a.je_source_name='#ALL#' ) order by upper(user_je_source_name) SELECT gjs.user_je_source_name FROM xla_subledgers xls, gl_je_sources gjs WHERE xls.application_id = fnd_global.RESP_APPL_ID AND gjs.je_source_name = xls.je_source_name Y JA 仕訳ソース 仕訳ソース名 KO 분개 출처 분개 출처명 US Journal Entry Source Journal Entry Source Name ZHS 日记帐分录来源 日记帐分录来源名称 17 100 :p_party_type LOV Oracle JGSLA_SRS_PARTY_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups lk where lk.lookup_type='GL_CONTROL_ACCOUNT_SOURCES' and lk.lookup_code not in ('N','Y') and lk.lookup_code in ( select decode(xs.control_account_type_code,'Y', lk.lookup_code,xs.control_account_type_code) from xla_subledgers xs where :$flex$.jgsla_srs_je_sources_all in ('#ALL#',xs.je_source_name)) order by value,description select lk.meaning from fnd_lookups lk, xla_subledgers xs where lk.lookup_type = 'GL_CONTROL_ACCOUNT_SOURCES' and lk.lookup_code not in ('N', 'Y') and lk.lookup_code = xs.control_account_type_code and xs.application_id = fnd_global.RESP_APPL_ID Y JA パーティ・タイプ パーティ・タイプ KO 제3자 유형 제3자 유형 US Third Party Type Third Party Type ZHS 第三方类型 第三方类型 18 110 :p_third_party_name_from LOV Oracle JAJP_SRS_PARTY_NAME_FROM Y select tab.pn id, tab.pn value, null description from ((select vendor_id party_id,vendor_name pn,segment1 pnum,'S' pt from ap_suppliers) union (select a.cust_account_id,b.party_name pn,account_number pnum,'C' pt from hz_cust_accounts a,hz_parties b where a.party_id=b.party_id)) tab where tab.pt=decode(:$flex$.jgsla_srs_party_type,'SUPPLIER','S','CUSTOMER','C') order by tab.pn JA パーティ名: 自 パーティ名: 自 KO 제3자 시작 이름 제3자 시작 이름 US Third Party Name From Third Party Name From ZHS 第三方名称自 第三方名称自 19 120 :p_third_party_name_to LOV Oracle JAJP_SRS_PARTY_NAME_TO Y select tab.pn id, tab.pn value, null description from ((select vendor_id party_id,vendor_name pn,segment1 pnum,'S' pt from ap_suppliers) union (select a.cust_account_id,b.party_name pn,account_number pnum,'C' pt from hz_cust_accounts a,hz_parties b where a.party_id=b.party_id)) tab where tab.pt=decode(:$flex$.jgsla_srs_party_type,'SUPPLIER','S','CUSTOMER','C') and tab.pn>=:$flex$.jajp_srs_party_name_from order by tab.pn JA パーティ名: 至 パーティ名: 至 KO 제3자 종료 이름 제3자 종료 이름 US Third Party Name To Third Party Name To ZHS 第三方名称至 第三方名称至 20 130 :p_third_party_number_from LOV Oracle JG_SRS_PARTY_NUMBER_FROM Y select tab.party_number id, tab.party_number value, null description from ((select segment1 party_number,vendor_id party_num_id,'S' party_type from ap_suppliers) union (select account_number party_number,cust_account_id party_num_id,'C' party_type from hz_cust_accounts)) tab where tab.party_type=decode((select 1 from xla_subledgers where je_source_name=:$flex$.jgsla_srs_je_sources_all) ,1,(select decode(control_account_type_code,'SUPPLIER','S','CUSTOMER','C') from xla_subledgers where je_source_name=:$flex$.jgsla_srs_je_sources_all) ) order by tab.party_number JA パーティ番号: 自 パーティ番号: 自 KO 제3자 시작 번호 제3자 시작 번호 US Third Party Number From Third Party Number From ZHS 第三方编号自 第三方编号自 21 140 :p_third_party_number_to LOV Oracle JG_SRS_PARTY_NUMBER_TO Y select tab.party_number id, tab.party_number value, null description from ((select segment1 party_number,vendor_id party_num_id,'S' party_type from ap_suppliers) union (select account_number party_number,cust_account_id party_num_id,'C' party_type from hz_cust_accounts)) tab where tab.party_type=decode(:$flex$.jgsla_srs_party_type,'SUPPLIER','S','CUSTOMER','C') and tab.party_number>=:$flex$.jg_srs_party_number_from order by tab.party_number JA パーティ番号: 至 パーティ番号: 至 KO 제3자 종료 번호 제3자 종료 번호 US Third Party Number To Third Party Number To ZHS 第三方编号至 第三方编号至 22 150 :p_third_party_site_name_from LOV Oracle JAJP_SRS_PARTY_SITE_NAME_FROM Y select hps.party_site_name id, hps.party_site_name value, null description from ((select party_site_id,'S' pt from ap_supplier_sites_all) union (select party_site_id,'C' pt from hz_cust_acct_sites_all hcas)) tab,hz_party_sites hps where tab.pt=decode(:$flex$.jgsla_srs_party_type,'SUPPLIER','S','CUSTOMER','C') and hps.party_site_id=tab.party_site_id order by hps.party_site_name JA パーティ・サイト: 自 パーティ・サイト: 自 KO 제3자 시작 사업장명 제3자 시작 사업장명 US Third Party Site Name From Third Party Site Name From ZHS 第三方地点名称自 第三方地点名称自 23 160 :p_third_party_site_name_to LOV Oracle JAJP_SRS_PARTY_SITE_NAME_TO Y select hps.party_site_name id, hps.party_site_name value, null description from ((select party_site_id,'S' pt from ap_supplier_sites_all) union (select party_site_id,'C' pt from hz_cust_acct_sites_all hcas)) tab,hz_party_sites hps where tab.pt=decode(:$flex$.jgsla_srs_party_type,'SUPPLIER','S','CUSTOMER','C') and hps.party_site_id=tab.party_site_id and hps.party_site_name>=:$flex$.jajp_srs_party_site_name_from order by hps.party_site_name JA パーティ・サイト: 至 パーティ・サイト: 至 KO 제3자 종료 사업장명 제3자 종료 사업장명 US Third Party Site Name To Third Party Site Name To ZHS 第三方地点名称至 第三方地点名称至 24 170 :p_dist_acct_flexfield_from Char JA 配分会計フレックスフィールド: 自 配分会計フレックスフィールド: 自 KO 분배 회계 시작 가변필드 분배 회계 시작 가변필드 US Distribution Accounting Flexfield From Distribution Accounting Flex Field From ZHS 分配会计科目弹性域自 分配会计科目弹性域自 25 180 :p_dist_acct_flexfield_to Char JA 配分会計フレックスフィールド: 至 配分会計フレックスフィールド: 自 KO 분배 회계 종료 가변필드 분배 회계 시작 가변필드 US Distribution Accounting Flexfield To Distribution Accounting Flex Field From ZHS 分配会计科目弹性域至 分配会计科目弹性域自 26 190 :p_document_sequence_name LOV Oracle JAJP_DOC_SEQ_NAME Y select doc_sequence_id id, name value, null description from fnd_document_sequences where ((:$flex$.jgsla_srs_party_type='SUPPLIER' and application_id=200) or(:$flex$.jgsla_srs_party_type='CUSTOMER' and application_id=222) ) order by value,description JA 文書連番名 文書連番名 KO 문서 순번명 문서 순번명 US Document Sequence Name Document Sequence Name ZHS 单据序列名称 单据序列名称 27 200 :p_doc_sequence_number_from Number JA 文書連番: 自 文書連番: 自 KO 문서 시작 순번 문서 시작 순번 US Document Sequence From Document Sequence From ZHS 单据序列自 单据序列自 28 210 :p_doc_sequence_number_to Number JA 文書連番: 至 文書連番: 至 KO 문서 종료 순번 문서 종료 순번 US Document Sequence To Document Sequence To ZHS 单据序列至 单据序列至 29 220 :p_dist_dr_cr LOV Oracle JAJP_ACCT_BALANCE_SIDE Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_ADR_SIDE' and lookup_code in ('DEBIT','CREDIT') order by value,description JA 配分金額借方/貸方 配分金額借方/貸方 KO 분배 금액 차변 또는 대변 분배 금액 차변 또는 대변 US Distribution Amount Debit or Credit Distribution Amount Debit or Credit ZHS 分配额借项或贷项 分配额借项或贷项 30 230 :p_dist_amt_from Number JA 配分金額: 自 配分金額: 自 KO 분배 시작 금액 분배 시작 금액 US Distribution Amount From Distribution Amount From ZHS 分配额自 分配额自 31 240 :p_dist_amt_to Number JA 配分金額: 至 配分金額: 至 KO 분배 종료 금액 분배 종료 금액 US Distribution Amount To Distribution Amount To ZHS 分配额至 分配额至 32 250 :p_include_draft_activity 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' JA 草案活動を含む 草案活動を含む KO 초안 활동 포함 초안 활동 포함 US Include Draft Activity Include Draft Activity ZHS 包括拟定活动 包括拟定活动 33 260 :p_gl_transfer_status LOV Oracle JGZZ_SRS_SLR_POST_STAT Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JGZZ_SRS_SLR_POST_STAT' order by value,description JA GL転送ステータス GL転送ステータス KO GL 이전 상태 GL 이전 상태 US GL Transfer Status GL Transfer Status ZHS GL 传送状态 GL 传送状态