22162: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22163: AND(
22164: fdfcu.descriptive_flex_context_code IN(
22165: SELECT fdfc.descriptive_flex_context_code
22166: FROM fnd_descr_flex_contexts_vl fdfc
22167: WHERE fdfc.global_flag = 'Y'
22168: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22169: AND fdfc.application_id = fa.application_id)
22170: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
22213: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22214: AND(
22215: fdfcu.descriptive_flex_context_code IN(
22216: SELECT fdfc.descriptive_flex_context_code
22217: FROM fnd_descr_flex_contexts_vl fdfc
22218: WHERE fdfc.global_flag = 'Y'
22219: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22220: AND fdfc.application_id = fa.application_id)
22221: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
22307: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22308: AND(
22309: fdfcu.descriptive_flex_context_code IN(
22310: SELECT fdfc.descriptive_flex_context_code
22311: FROM fnd_descr_flex_contexts_vl fdfc
22312: WHERE fdfc.global_flag = 'Y'
22313: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22314: AND fdfc.application_id = fa.application_id)
22315: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
22358: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22359: AND(
22360: fdfcu.descriptive_flex_context_code IN(
22361: SELECT fdfc.descriptive_flex_context_code
22362: FROM fnd_descr_flex_contexts_vl fdfc
22363: WHERE fdfc.global_flag = 'Y'
22364: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22365: AND fdfc.application_id = fa.application_id)
22366: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code