eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BOM_BOMRBOMC_XMLP_PKG dependencies on MFG_LOOKUPS

Line 241: TABLE_NAME := 'MFG_LOOKUPS1';

237: MTL_CATEGORY_SETS
238: WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;
239: P_CATEGORY_SET := L_CATEGORY_SET;
240: END IF;
241: TABLE_NAME := 'MFG_LOOKUPS1';
242: SELECT
243: SUBSTR(L1.MEANING
244: ,1
245: ,40),

Line 260: MFG_LOOKUPS L1,

256: ,1
257: ,4)
258: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
259: FROM
260: MFG_LOOKUPS L1,
261: MFG_LOOKUPS L2,
262: MFG_LOOKUPS L3,
263: MFG_LOOKUPS L4,
264: MFG_LOOKUPS L5

Line 261: MFG_LOOKUPS L2,

257: ,4)
258: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
259: FROM
260: MFG_LOOKUPS L1,
261: MFG_LOOKUPS L2,
262: MFG_LOOKUPS L3,
263: MFG_LOOKUPS L4,
264: MFG_LOOKUPS L5
265: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'

Line 262: MFG_LOOKUPS L3,

258: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
259: FROM
260: MFG_LOOKUPS L1,
261: MFG_LOOKUPS L2,
262: MFG_LOOKUPS L3,
263: MFG_LOOKUPS L4,
264: MFG_LOOKUPS L5
265: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
266: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE

Line 263: MFG_LOOKUPS L4,

259: FROM
260: MFG_LOOKUPS L1,
261: MFG_LOOKUPS L2,
262: MFG_LOOKUPS L3,
263: MFG_LOOKUPS L4,
264: MFG_LOOKUPS L5
265: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
266: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
267: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'

Line 264: MFG_LOOKUPS L5

260: MFG_LOOKUPS L1,
261: MFG_LOOKUPS L2,
262: MFG_LOOKUPS L3,
263: MFG_LOOKUPS L4,
264: MFG_LOOKUPS L5
265: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
266: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
267: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
268: AND L2.LOOKUP_CODE = P_IMPL_FLAG

Line 275: TABLE_NAME := 'MFG_LOOKUPS2';

271: AND L4.LOOKUP_TYPE = 'SYS_YES_NO'
272: AND L4.LOOKUP_CODE = P_PRINT_OPTION1_FLAG
273: AND L5.LOOKUP_TYPE = 'SYS_YES_NO'
274: AND L5.LOOKUP_CODE = P_PLAN_FACTOR_FLAG;
275: TABLE_NAME := 'MFG_LOOKUPS2';
276: SELECT
277: SUBSTR(L1.MEANING
278: ,1
279: ,40),

Line 285: MFG_LOOKUPS L1,

281: ,1
282: ,40)
283: INTO L_ALT_OPTION,L_ORDER_BY
284: FROM
285: MFG_LOOKUPS L1,
286: MFG_LOOKUPS L2
287: WHERE L1.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
288: AND L1.LOOKUP_CODE = P_ALT_OPTION_TYPE
289: AND L2.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'

Line 286: MFG_LOOKUPS L2

282: ,40)
283: INTO L_ALT_OPTION,L_ORDER_BY
284: FROM
285: MFG_LOOKUPS L1,
286: MFG_LOOKUPS L2
287: WHERE L1.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
288: AND L1.LOOKUP_CODE = P_ALT_OPTION_TYPE
289: AND L2.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'
290: AND L2.LOOKUP_CODE = P_ORDER_BY_TYPE;