APPS.WIP_WIPRDJVR_XMLP_PKG dependencies on MFG_LOOKUPS

Line 120: MFG_LOOKUPS RPT_SORT_OPT,

116: FROM
117: FND_CURRENCIES FC,
118: GL_SETS_OF_BOOKS SOB,
119: ORG_ORGANIZATION_DEFINITIONS OOD,
120: MFG_LOOKUPS RPT_SORT_OPT,
121: MFG_LOOKUPS RPT_RUN_OPT,
122: MFG_LOOKUPS ML1,
123: MFG_LOOKUPS ML2
124: WHERE OOD.ORGANIZATION_ID = ORG_ID

Line 121: MFG_LOOKUPS RPT_RUN_OPT,

117: FND_CURRENCIES FC,
118: GL_SETS_OF_BOOKS SOB,
119: ORG_ORGANIZATION_DEFINITIONS OOD,
120: MFG_LOOKUPS RPT_SORT_OPT,
121: MFG_LOOKUPS RPT_RUN_OPT,
122: MFG_LOOKUPS ML1,
123: MFG_LOOKUPS ML2
124: WHERE OOD.ORGANIZATION_ID = ORG_ID
125: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 122: MFG_LOOKUPS ML1,

118: GL_SETS_OF_BOOKS SOB,
119: ORG_ORGANIZATION_DEFINITIONS OOD,
120: MFG_LOOKUPS RPT_SORT_OPT,
121: MFG_LOOKUPS RPT_RUN_OPT,
122: MFG_LOOKUPS ML1,
123: MFG_LOOKUPS ML2
124: WHERE OOD.ORGANIZATION_ID = ORG_ID
125: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
126: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE

Line 123: MFG_LOOKUPS ML2

119: ORG_ORGANIZATION_DEFINITIONS OOD,
120: MFG_LOOKUPS RPT_SORT_OPT,
121: MFG_LOOKUPS RPT_RUN_OPT,
122: MFG_LOOKUPS ML1,
123: MFG_LOOKUPS ML2
124: WHERE OOD.ORGANIZATION_ID = ORG_ID
125: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
126: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
127: AND FC.ENABLED_FLAG = 'Y'

Line 145: MFG_LOOKUPS CLS_TYPE

141: SELECT
142: CLS_TYPE.MEANING
143: INTO CLASS_TYPE_NAME
144: FROM
145: MFG_LOOKUPS CLS_TYPE
146: WHERE CLS_TYPE.LOOKUP_TYPE = 'WIP_CLASS_TYPE'
147: AND CLS_TYPE.LOOKUP_CODE = CLASS_TYPE;
148: END IF;
149: IF STATUS_TYPE IS NULL THEN

Line 156: MFG_LOOKUPS STS_TYPE

152: SELECT
153: STS_TYPE.MEANING
154: INTO STATUS_TYPE_NAME
155: FROM
156: MFG_LOOKUPS STS_TYPE
157: WHERE STS_TYPE.LOOKUP_TYPE = 'WIP_JOB_STATUS'
158: AND STS_TYPE.LOOKUP_CODE = STATUS_TYPE;
159: END IF;
160: IF (JOB_FROM IS NULL) AND (JOB_TO IS NULL) THEN