WIP Purge

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: WIP Purge (XML)
Short Name: WIPPURGE_XML
DB package: WIP_WIPPURGE_XMLP_PKG
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
Organization ID
 
Number
Days Before Cutoff Date
 
Number
Report Type
 
LOV Oracle
Resource Transactions
 
LOV Oracle
Move Transactions
 
LOV Oracle
Details
 
LOV Oracle
Headers
 
LOV Oracle
Include Configurations
 
LOV Oracle
Cutoff Datetime
 
DateTime
Assembly
 
Line
 
LOV Oracle
To
 
LOV Oracle
Jobs From
 
LOV Oracle
Action Type
 
LOV Oracle
Selection Type
 
LOV Oracle