115: FROM
116: FND_CURRENCIES FC,
117: GL_SETS_OF_BOOKS SOB,
118: ORG_ORGANIZATION_DEFINITIONS OOD,
119: MFG_LOOKUPS RPT_SORT_OPT,
120: MFG_LOOKUPS RPT_RUN_OPT,
121: MFG_LOOKUPS ML1,
122: MFG_LOOKUPS ML2
123: WHERE OOD.ORGANIZATION_ID = ORG_ID
116: FND_CURRENCIES FC,
117: GL_SETS_OF_BOOKS SOB,
118: ORG_ORGANIZATION_DEFINITIONS OOD,
119: MFG_LOOKUPS RPT_SORT_OPT,
120: MFG_LOOKUPS RPT_RUN_OPT,
121: MFG_LOOKUPS ML1,
122: MFG_LOOKUPS ML2
123: WHERE OOD.ORGANIZATION_ID = ORG_ID
124: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
117: GL_SETS_OF_BOOKS SOB,
118: ORG_ORGANIZATION_DEFINITIONS OOD,
119: MFG_LOOKUPS RPT_SORT_OPT,
120: MFG_LOOKUPS RPT_RUN_OPT,
121: MFG_LOOKUPS ML1,
122: MFG_LOOKUPS ML2
123: WHERE OOD.ORGANIZATION_ID = ORG_ID
124: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
125: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
118: ORG_ORGANIZATION_DEFINITIONS OOD,
119: MFG_LOOKUPS RPT_SORT_OPT,
120: MFG_LOOKUPS RPT_RUN_OPT,
121: MFG_LOOKUPS ML1,
122: MFG_LOOKUPS ML2
123: WHERE OOD.ORGANIZATION_ID = ORG_ID
124: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
125: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
126: AND RPT_SORT_OPT.LOOKUP_TYPE = 'CST_WIP_REPORT_SORT'
149: FROM
150: FND_CURRENCIES FC,
151: GL_SETS_OF_BOOKS SOB,
152: ORG_ORGANIZATION_DEFINITIONS OOD,
153: MFG_LOOKUPS RPT_SORT_OPT,
154: MFG_LOOKUPS RPT_RUN_OPT,
155: MFG_LOOKUPS ML1,
156: MFG_LOOKUPS ML2
157: WHERE OOD.ORGANIZATION_ID = ORG_ID
150: FND_CURRENCIES FC,
151: GL_SETS_OF_BOOKS SOB,
152: ORG_ORGANIZATION_DEFINITIONS OOD,
153: MFG_LOOKUPS RPT_SORT_OPT,
154: MFG_LOOKUPS RPT_RUN_OPT,
155: MFG_LOOKUPS ML1,
156: MFG_LOOKUPS ML2
157: WHERE OOD.ORGANIZATION_ID = ORG_ID
158: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
151: GL_SETS_OF_BOOKS SOB,
152: ORG_ORGANIZATION_DEFINITIONS OOD,
153: MFG_LOOKUPS RPT_SORT_OPT,
154: MFG_LOOKUPS RPT_RUN_OPT,
155: MFG_LOOKUPS ML1,
156: MFG_LOOKUPS ML2
157: WHERE OOD.ORGANIZATION_ID = ORG_ID
158: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
159: AND FC.CURRENCY_CODE = LP_CURRENCY_CODE
152: ORG_ORGANIZATION_DEFINITIONS OOD,
153: MFG_LOOKUPS RPT_SORT_OPT,
154: MFG_LOOKUPS RPT_RUN_OPT,
155: MFG_LOOKUPS ML1,
156: MFG_LOOKUPS ML2
157: WHERE OOD.ORGANIZATION_ID = ORG_ID
158: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
159: AND FC.CURRENCY_CODE = LP_CURRENCY_CODE
160: AND RPT_SORT_OPT.LOOKUP_TYPE = 'CST_WIP_REPORT_SORT'
184: SELECT
185: CLS_TYPE.MEANING
186: INTO CLASS_TYPE_NAME
187: FROM
188: MFG_LOOKUPS CLS_TYPE
189: WHERE CLS_TYPE.LOOKUP_TYPE = 'WIP_CLASS_TYPE'
190: AND CLS_TYPE.LOOKUP_CODE = CLASS_TYPE;
191: END IF;
192: IF STATUS_TYPE IS NULL THEN
195: SELECT
196: STS_TYPE.MEANING
197: INTO STATUS_TYPE_NAME
198: FROM
199: MFG_LOOKUPS STS_TYPE
200: WHERE STS_TYPE.LOOKUP_TYPE = 'WIP_JOB_STATUS'
201: AND STS_TYPE.LOOKUP_CODE = STATUS_TYPE;
202: END IF;
203: IF (JOB_FROM IS NULL) AND (JOB_TO IS NULL) AND (P_COST_GROUP_ID IS NULL) THEN