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
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:
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
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
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
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
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
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''
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
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''
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