DBA Data[Home] [Help]

APPS.BOM_CSTRDJVA_XMLP_PKG dependencies on MFG_LOOKUPS

Line 119: MFG_LOOKUPS RPT_SORT_OPT,

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

Line 120: MFG_LOOKUPS RPT_RUN_OPT,

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

Line 121: MFG_LOOKUPS ML1,

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

Line 122: MFG_LOOKUPS ML2

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'

Line 153: MFG_LOOKUPS RPT_SORT_OPT,

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

Line 154: MFG_LOOKUPS RPT_RUN_OPT,

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

Line 155: MFG_LOOKUPS ML1,

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

Line 156: MFG_LOOKUPS ML2

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'

Line 188: MFG_LOOKUPS CLS_TYPE

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

Line 199: MFG_LOOKUPS STS_TYPE

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