WIP Purge

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: WIP Purge
Application: Work in Process
Source: WIP Purge (XML)
Short Name: WIPPURGE_XML
DB package: WIP_WIPPURGE_XMLP_PKG
Run WIP Purge and other Oracle EBS reports with Blitz Report™ on our demo environment
Select oog.organization_name             Organization_name
,      ML.MEANING                                  Purge_Entity_Type
,      ML1.MEANING                                Purge_Option
,      ML2.MEANING                                Purge_Report_Type
,      decode(:P_Conf_Flag,
	'','',
	 ML3.MEANING)                  Include_Config
,      ML4.MEANING                                Detail
,      ML5.MEANING                                Move_Txn
,      ML6.MEANING                                Cost_Txn
,      ML7.MEANING                                Header
,      wip_discrete_ws_move.servertoclientdate(sysdate) report_date
from   org_organization_definitions oog
,      MFG_LOOKUPS ML
,      MFG_LOOKUPS ML1
,      MFG_LOOKUPS ML2
,      MFG_LOOKUPS ML3
,      MFG_LOOKUPS ML4
,      MFG_LOOKUPS ML5
,      MFG_LOOKUPS ML6
,      MFG_LOOKUPS ML7
where  oog.organization_id = :P_Organization_Id
AND    ML.LOOKUP_CODE = :P_PURGE_TYPE
AND    ML.LOOKUP_TYPE = 'WIP_PURGE_ENTITIES'
AND    ML1.LOOKUP_CODE = :P_OPTION
AND    ML1.LOOKUP_TYPE = 'WIP_PURGE_OPTIONS'
AND    ML2.LOOKUP_CODE = NVL(:P_REPORT_OPTION,1)
AND    ML2.LOOKUP_TYPE = 'WIP_PURGE_REPORT_TYPE'
AND    ML3.LOOKUP_CODE = NVL(:P_Conf_Flag,2)
AND    ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND    ML4.LOOKUP_CODE = :P_Detail_Flag
AND    ML4.LOOKUP_TYPE = 'SYS_YES_NO'
AND    ML5.LOOKUP_CODE = :P_Move_Txn_Flag
AND    ML5.LOOKUP_TYPE = 'SYS_YES_NO'
AND    ML6.LOOKUP_CODE = :P_Cost_Trx_Flag
AND    ML6.LOOKUP_TYPE = 'SYS_YES_NO'
AND    ML7.LOOKUP_CODE = :P_Header_Flag
AND    ML7.LOOKUP_TYPE = 'SYS_YES_NO'
Parameter Name SQL text Validation
Selection Type 
 
 LOV Oracle
Action Type 
 
 LOV Oracle
Jobs From 
 
 LOV Oracle
To 
 
 LOV Oracle
Line 
 
 LOV Oracle
Assembly 
 
 Char
Cutoff Datetime 
 
 DateTime
Include Configurations 
 
 LOV Oracle
Headers 
 
 LOV Oracle
Details 
 
 LOV Oracle
Move Transactions 
 
 LOV Oracle
Resource Transactions 
 
 LOV Oracle
Report Type 
 
 LOV Oracle
Days Before Cutoff Date 
 
 Number
Download
 
Related Blitz Reports
CAC Shipping Network (Inter-Org) Accounts Setup CAC Inventory Periods Not Closed or Summarized INV Item replenishment count CAC WIP Account Summary INV Organization parameters listing CAC Shipping Networks Missing Interco OU Relationships CAC Intransit Value (Real-Time) CAC Missing Material Accounting Transactions CAC Missing WIP Accounting Transactions INV Cycle count unscheduled items
Blitz Report™

Blitz Report™ provides multiple benefits: