WIP Account Distribution
Description
Categories: Enginatics
Repository: Github
Repository: Github
Detail WIP report that lists resource transaction account distributions.
Run
WIP Account Distribution and other Oracle EBS reports with Blitz Report™ on our demo environment
select ood.organization_code, ood.organization_name, wta.transaction_date, we.wip_entity_name job_schedule, msiv.concatenated_segments assembly, msiv.description assembly_description, wl.line_code line, wta.transaction_id, wt.operation_seq_num operation_seq, bd.department_code department, wt.resource_seq_num resource_seq, br.resource_code, br.description resource_description, muot.unit_of_measure_tl uom, xxen_util.meaning(wta.basis_type,'CST_BASIS',700) basis, wta.primary_quantity quantity, wta.rate_or_amount unit_cost, xxen_util.meaning(br.cost_code_type,'CST_COST_CODE_TYPE',700) cost_type, xxen_util.meaning(wta.accounting_line_type,'CST_ACCOUNTING_LINE_TYPE',700) accounting_line_type, gcck.concatenated_segments account, wta.base_transaction_value value, gl.currency_code, wta.transaction_value orig_value, decode(wta.currency_code,gl.currency_code,null,wta.currency_code) orig_currency, decode(wta.currency_code,gl.currency_code,null,wta.currency_conversion_rate) conversion_rate, decode(wta.currency_code,gl.currency_code,null,wta.currency_conversion_date) conversion_date, xxen_util.meaning(wt.transaction_type,'WIP_TRANSACTION_TYPE',700) transaction_type, ca.activity, xxen_util.meaning(wt.standard_rate_flag,'SYS_YES_NO',700) standard_rate, xxen_util.segments_description(wta.reference_account,gl.chart_of_accounts_id) account_description, &gl_account_segments nvl(wri.class_code,wdj.class_code) accounting_class, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) type, xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type, xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, mck.concatenated_segments item_category, nvl(ppx.npw_number,ppx.employee_number) employee_num, ppx.full_name employee, poh.segment1 po_number, gl.name ledger, wta.gl_batch_id gl_batch, ogb.gl_batch_date, ogb.description gl_batch_description, wta.wip_entity_id from wip_transaction_accounts wta, wip_transactions wt, wip_entities we, wip_discrete_jobs wdj, gl_code_combinations_kfv gcck, wip_lines wl, mtl_item_categories mic, mtl_categories_kfv mck, mtl_system_items_vl msiv, wip_repetitive_items wri, bom_departments bd, bom_resources br, mtl_units_of_measure_tl muot, cst_activities ca, org_organization_definitions ood, gl_ledgers gl, org_gl_batches ogb, per_people_x ppx, po_headers_all poh where 1=1 and wta.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and wta.accounting_line_type<>15 and wta.transaction_id=wt.transaction_id and wta.wip_entity_id=we.wip_entity_id and wta.wip_entity_id=wdj.wip_entity_id(+) and wta.organization_id=wdj.organization_id(+) and wta.reference_account=gcck.code_combination_id and wt.line_id=wl.line_id(+) and wt.organization_id=wl.organization_id(+) and we.organization_id=mic.organization_id(+) and we.primary_item_id=mic.inventory_item_id(+) and mic.category_set_id(+)=:category_set_id and mic.category_id=mck.category_id(+) and we.organization_id=msiv.organization_id(+) and we.primary_item_id=msiv.inventory_item_id(+) and wt.organization_id=wri.organization_id(+) and wt.wip_entity_id=wri.wip_entity_id(+) and wt.line_id=wri.line_id(+) and wt.department_id=bd.department_id(+) and wta.resource_id=br.resource_id(+) and br.unit_of_measure=muot.uom_code(+) and muot.language(+)=userenv('lang') and wta.activity_id=ca.activity_id(+) and wta.organization_id=ood.organization_id and ood.set_of_books_id=gl.ledger_id and wta.organization_id=ogb.organization_id(+) and wta.gl_batch_id=ogb.gl_batch_id(+) and ppx.person_id(+)=wt.employee_id and poh.po_header_id(+)=wt.po_header_id order by ood.organization_code, ood.organization_name, wta.transaction_date desc, wta.transaction_id desc, cost_type, accounting_line_type |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV | |
Date From |
|
DateTime | |
Date To |
|
DateTime | |
Account |
|
LOV | |
Job |
|
LOV | |
Line |
|
LOV Oracle | |
Item |
|
LOV | |
Transaction Type |
|
LOV Oracle | |
Department |
|
LOV Oracle | |
Resource |
|
LOV Oracle | |
Activity |
|
LOV Oracle | |
Class |
|
LOV | |
Currency |
|
LOV Oracle | |
Category Set |
|
LOV Oracle | |
Category |
|
LOV | |
Project Id |
|
LOV Oracle | |
Employee Number |
|
LOV | |
PO Number |
|
Char |