66: FROM
67: FND_CURRENCIES FC,
68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
67: FND_CURRENCIES FC,
68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
75: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
75: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
76: AND FC.ENABLED_FLAG = 'Y'
86: SELECT
87: STS_TYPE.MEANING
88: INTO STATUS_TYPE_NAME
89: FROM
90: MFG_LOOKUPS STS_TYPE
91: WHERE STS_TYPE.LOOKUP_TYPE = 'WIP_JOB_STATUS'
92: AND STS_TYPE.LOOKUP_CODE = STATUS_TYPE;
93: END IF;
94: IF (JOB_FROM IS NULL) AND (JOB_TO IS NULL) THEN