APPS.INV_XML_REPORTS dependencies on MFG_LOOKUPS

Line 212: , mfg_lookups mfgl

208: , mln.parent_lot_number
209: , mln.vendor_name
210: , mln.supplier_lot_number
211: FROM mtl_lot_numbers mln
212: , mfg_lookups mfgl
213: WHERE msi.organization_id = mln.organization_id
214: AND msi.inventory_item_id = mln.inventory_item_id
215: AND mln.origination_type = mfgl.LOOKUP_CODE(+)
216: AND mfgl.lookup_type(+) = ''MTL_LOT_ORIGINATION_TYPE'') as LOT_DETAILS

Line 287: FROM mfg_lookups

283: END IF;
284:
285: SELECT meaning
286: INTO l_order_display
287: FROM mfg_lookups
288: WHERE lookup_type = 'INV_SRS_ASC_DESC'
289: AND enabled_flag = 'Y'
290: AND lookup_code = NVL(p_sort_order, 1);
291:

Line 329: , mfg_lookups ml1

325: from mtl_status_control_v tx
326: where tx.status_id = mv.status_id and tx.is_allowed = 2
327: order by tx.transaction_description) as disallowed_transactions
328: FROM mtl_material_statuses_vl mv
329: , mfg_lookups ml1
330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5

Line 330: , mfg_lookups ml2

326: where tx.status_id = mv.status_id and tx.is_allowed = 2
327: order by tx.transaction_description) as disallowed_transactions
328: FROM mtl_material_statuses_vl mv
329: , mfg_lookups ml1
330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6

Line 331: , mfg_lookups ml3

327: order by tx.transaction_description) as disallowed_transactions
328: FROM mtl_material_statuses_vl mv
329: , mfg_lookups ml1
330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7

Line 332: , mfg_lookups ml4

328: FROM mtl_material_statuses_vl mv
329: , mfg_lookups ml1
330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8

Line 333: , mfg_lookups ml5

329: , mfg_lookups ml1
330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8
337: , mfg_lookups m19

Line 334: , mfg_lookups ml6

330: , mfg_lookups ml2
331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8
337: , mfg_lookups m19
338: WHERE ml1.lookup_code = mv.enabled_flag

Line 335: , mfg_lookups ml7

331: , mfg_lookups ml3
332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8
337: , mfg_lookups m19
338: WHERE ml1.lookup_code = mv.enabled_flag
339: and ml1.lookup_type = ''SYS_YES_NO''

Line 336: , mfg_lookups ml8

332: , mfg_lookups ml4
333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8
337: , mfg_lookups m19
338: WHERE ml1.lookup_code = mv.enabled_flag
339: and ml1.lookup_type = ''SYS_YES_NO''
340: and ml2.lookup_code = mv.reservable_type

Line 337: , mfg_lookups m19

333: , mfg_lookups ml5
334: , mfg_lookups ml6
335: , mfg_lookups ml7
336: , mfg_lookups ml8
337: , mfg_lookups m19
338: WHERE ml1.lookup_code = mv.enabled_flag
339: and ml1.lookup_type = ''SYS_YES_NO''
340: and ml2.lookup_code = mv.reservable_type
341: and ml2.lookup_type = ''SYS_YES_NO''

Line 441: , mfg_lookups ml

437: , mtl_grades_vl mg1
438: , mtl_grades_vl mg2
439: , mtl_transaction_reasons mtr
440: , fnd_user fnd
441: , mfg_lookups ml
442: where msi.organization_id = mlgh.organization_id
443: AND msi.inventory_item_id = mlgh.inventory_item_id
444: AND mlgh.old_grade_code = mg1.grade_code
445: AND mlgh.new_grade_code = mg2.grade_code