INV Cycle count schedule requests
Description
Categories: Enginatics
Repository: Github
Repository: Github
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
Source: Cycle count schedule requests report (XML)
Short Name: INVARRTA_XML
DB package: INV_INVARRTA_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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, 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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV | |
Cycle Count Name |
|
LOV | |
Start Date |
|
Date | |
End Date |
|
Date |