Oracle-EBS-SQL/INV Cycle count schedule requests/INV Cycle count schedule requests.sql at master · Enginatics/Oracle-EBS-SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
/*************************************************************************/
/*                                                                       */
/*                       (c) 2010-2024 Enginatics GmbH                   */
/*                              www.enginatics.com                       */
/*                                                                       */
/*************************************************************************/
-- Report Name: INV Cycle count schedule requests
-- Description: Imported Oracle standard Cycle count schedule requests report
Source: Cycle count schedule requests report (XML)
Short Name: INVARRTA_XML
DB package: INV_INVARRTA_XMLP_PKG
-- Excel Examle Output: https://www.enginatics.com/example/inv-cycle-count-schedule-requests/
-- Library Link: https://www.enginatics.com/reports/inv-cycle-count-schedule-requests/
-- Run Report: https://demo.enginatics.com/

select
ood.organization_code,
ood.organization_name,
gl.currency_code,
mcch.cycle_count_header_name cycle_count_name,
msiv.concatenated_segments item,
msiv.description description,
&category_columns
xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type,
mcsr.subinventory subinventory,
mcsr.revision revision,
mcsr.lot_number lot_number,
nvl(inv_project.get_locator(milk.inventory_location_id,milk.organization_id),milk.concatenated_segments) locator,
milk.description locator_description,
mcsr.schedule_date request_date,
mcsr.count_due_date due_date,
xxen_util.meaning(mcsr.request_source_type,'MTL_CC_SOURCE_TYPES',700) request_type,
mcsr.serial_number
from
mtl_cycle_count_headers mcch,
mtl_cc_schedule_requests mcsr,
mtl_item_locations_kfv milk,
mtl_system_items_vl msiv,
org_organization_definitions ood,
gl_ledgers gl
where
1=1 and
mcch.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
nvl(mcch.disable_date,sysdate+1)>sysdate and
mcch.cycle_count_header_id=mcsr.cycle_count_header_id and
mcch.organization_id=milk.organization_id(+) and
mcsr.locator_id=milk.inventory_location_id(+) and
mcch.organization_id=msiv.organization_id(+) and
mcsr.inventory_item_id=msiv.inventory_item_id(+) and
mcch.organization_id=ood.organization_id and
ood.set_of_books_id=gl.ledger_id
order by
ood.organization_code,
mcsr.schedule_date,
mcsr.subinventory,
mcsr.revision,
mcsr.request_source_type