WIP Purge
Description
- Categories
- BI Publisher
- Application
- Work in Process
- Source
- WIP Purge (XML)
- Short Name
- WIPPURGE_XML
- DB package
- WIP_WIPPURGE_XMLP_PKG
Imported from BI Publisher
WIP Purge
WIP Purge
SQL 39 lines
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' |
Parameters 14
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |