首页 > 代码库 > Oracle EBS-SQL (OM-5):检查订单事务处理类型.sql
Oracle EBS-SQL (OM-5):检查订单事务处理类型.sql
SELECT
HO.NAME OU 名称,
t.NAME 订单事务处理类型,
t.DESCRIPTION 事务处理描述,
b.TRANSACTION_TYPE_CODE 事务处理类型代码,
b.ORDER_CATEGORY_CODE 事务处理类型集,
b.START_DATE_ACTIVE 开始时间,
b.END_DATE_ACTIVE 结束时间,
b.CURRENCY_CODE 币种,
b.CONVERSION_TYPE_CODE 折换类型,
k1.CONCATENATED_SEGMENTS 销售成本会计,
apps.cux_get_gl_code_name(b.COST_OF_GOODS_SOLD_ACCOUNT) 销售成本会计描述,
ood.ORGANIZATION_NAME 仓库,
b.AGREEMENT_TYPE_CODE 协议类型,
b.ATTRIBUTE1 弹性栏位1,
rct.NAME 应收处理类型,
k2.CONCATENATED_SEGMENTS 应收帐户,
apps.cux_get_gl_code_name(k2.CODE_COMBINATION_ID) 应收帐户描述,
k3.CONCATENATED_SEGMENTS 收入帐户,
apps.cux_get_gl_code_name(k3.CODE_COMBINATION_ID) 收入帐户描述,
k4.CONCATENATED_SEGMENTS 纳税帐户,
apps.cux_get_gl_code_name(k4.CODE_COMBINATION_ID) 纳税帐户描述,
k5.CONCATENATED_SEGMENTS 运费帐户,
apps.cux_get_gl_code_name(k5.CODE_COMBINATION_ID) 运费帐户描述,
k6.CONCATENATED_SEGMENTS 结算帐户,
apps.cux_get_gl_code_name(k6.CODE_COMBINATION_ID) 结算帐户描述
FROM
apps.GL_CODE_COMBINATIONS_KFV K6,
apps.GL_CODE_COMBINATIONS_KFV K5,
apps.GL_CODE_COMBINATIONS_KFV K4,
apps.GL_CODE_COMBINATIONS_KFV K3,
apps.GL_CODE_COMBINATIONS_KFV K2,
apps.GL_CODE_COMBINATIONS_KFV K1,
apps.ORG_ORGANIZATION_DEFINITIONS ood,
hr_organization_units ho,
ra_cust_trx_types_all rct,
oe_transaction_types_tl t,
oe_transaction_types_all b
WHERE b.transaction_type_id = t.transaction_type_id
and t.LANGUAGE = ‘ZHS‘
and b.TRANSACTION_TYPE_CODE = ‘ORDER‘
--and b.TRANSACTION_TYPE_ID = 1359
and rct.CUST_TRX_TYPE_ID = b.CUST_TRX_TYPE_ID
and ho.ORGANIZATION_ID = b.ORG_ID
and b.WAREHOUSE_ID = ood.ORGANIZATION_ID(+)
and b.COST_OF_GOODS_SOLD_ACCOUNT = k1.CODE_COMBINATION_ID(+)
and rct.GL_ID_REC = k2.CODE_COMBINATION_ID(+)
and rct.GL_ID_REV = k3.CODE_COMBINATION_ID(+)
and rct.GL_ID_TAX = k4.CODE_COMBINATION_ID(+)
and rct.GL_ID_FREIGHT = k5.CODE_COMBINATION_ID(+)
and rct.GL_ID_CLEARING = k6.CODE_COMBINATION_ID(+)
-- and HO.NAME like ‘1%‘