DBA Data[Home] [Help]

APPS.INV_XML_REPORTS dependencies on MFG_LOOKUPS

Line 163: , mfg_lookups mfgl

159: , mln.parent_lot_number
160: , mln.vendor_name
161: , mln.supplier_lot_number
162: FROM mtl_lot_numbers mln
163: , mfg_lookups mfgl
164: WHERE msi.organization_id = mln.organization_id
165: AND msi.inventory_item_id = mln.inventory_item_id
166: AND mln.origination_type = mfgl.LOOKUP_CODE(+)
167: AND mfgl.lookup_type(+) = ''MTL_LOT_ORIGINATION_TYPE'') as LOT_DETAILS

Line 238: FROM mfg_lookups

234: END IF;
235:
236: SELECT meaning
237: INTO l_order_display
238: FROM mfg_lookups
239: WHERE lookup_type = 'INV_SRS_ASC_DESC'
240: AND enabled_flag = 'Y'
241: AND lookup_code = NVL(p_sort_order, 1);
242:

Line 279: , mfg_lookups ml1

275: from mtl_status_control_v tx
276: where tx.status_id = mv.status_id and tx.is_allowed = 2
277: order by tx.transaction_description) as disallowed_transactions
278: FROM mtl_material_statuses_vl mv
279: , mfg_lookups ml1
280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5

Line 280: , mfg_lookups ml2

276: where tx.status_id = mv.status_id and tx.is_allowed = 2
277: order by tx.transaction_description) as disallowed_transactions
278: FROM mtl_material_statuses_vl mv
279: , mfg_lookups ml1
280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6

Line 281: , mfg_lookups ml3

277: order by tx.transaction_description) as disallowed_transactions
278: FROM mtl_material_statuses_vl mv
279: , mfg_lookups ml1
280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7

Line 282: , mfg_lookups ml4

278: FROM mtl_material_statuses_vl mv
279: , mfg_lookups ml1
280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7
286: , mfg_lookups ml8

Line 283: , mfg_lookups ml5

279: , mfg_lookups ml1
280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7
286: , mfg_lookups ml8
287: WHERE ml1.lookup_code = mv.enabled_flag

Line 284: , mfg_lookups ml6

280: , mfg_lookups ml2
281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7
286: , mfg_lookups ml8
287: WHERE ml1.lookup_code = mv.enabled_flag
288: and ml1.lookup_type = ''SYS_YES_NO''

Line 285: , mfg_lookups ml7

281: , mfg_lookups ml3
282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7
286: , mfg_lookups ml8
287: WHERE ml1.lookup_code = mv.enabled_flag
288: and ml1.lookup_type = ''SYS_YES_NO''
289: and ml2.lookup_code = mv.reservable_type

Line 286: , mfg_lookups ml8

282: , mfg_lookups ml4
283: , mfg_lookups ml5
284: , mfg_lookups ml6
285: , mfg_lookups ml7
286: , mfg_lookups ml8
287: WHERE ml1.lookup_code = mv.enabled_flag
288: and ml1.lookup_type = ''SYS_YES_NO''
289: and ml2.lookup_code = mv.reservable_type
290: and ml2.lookup_type = ''SYS_YES_NO''

Line 387: , mfg_lookups ml

383: , mtl_grades_vl mg1
384: , mtl_grades_vl mg2
385: , mtl_transaction_reasons mtr
386: , fnd_user fnd
387: , mfg_lookups ml
388: where msi.organization_id = mlgh.organization_id
389: AND msi.inventory_item_id = mlgh.inventory_item_id
390: AND mlgh.old_grade_code = mg1.grade_code
391: AND mlgh.new_grade_code = mg2.grade_code