APPS.WIP_DIAG_DATA_COLL dependencies on MFG_LOOKUPS

Line 5302: 'mfg_lookups mlu1, ' ||

5298: 'gcck.concatenated_segments default_scrap_account, ' ||
5299: 'mtp.primary_cost_method primary_cost_method_code, ' ||
5300: 'wip2.system_option_id ' ||
5301: 'FROM ' ||
5302: 'mfg_lookups mlu1, ' ||
5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||

Line 5303: 'mfg_lookups mlu2, ' ||

5299: 'mtp.primary_cost_method primary_cost_method_code, ' ||
5300: 'wip2.system_option_id ' ||
5301: 'FROM ' ||
5302: 'mfg_lookups mlu1, ' ||
5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||
5307: 'mfg_lookups mlu6, ' ||

Line 5304: 'mfg_lookups mlu3, ' ||

5300: 'wip2.system_option_id ' ||
5301: 'FROM ' ||
5302: 'mfg_lookups mlu1, ' ||
5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||
5307: 'mfg_lookups mlu6, ' ||
5308: 'mtl_parameters mtp, ' ||

Line 5305: 'mfg_lookups mlu4, ' ||

5301: 'FROM ' ||
5302: 'mfg_lookups mlu1, ' ||
5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||
5307: 'mfg_lookups mlu6, ' ||
5308: 'mtl_parameters mtp, ' ||
5309: 'mtl_parameters mpm, ' ||

Line 5306: 'mfg_lookups mlu5, ' ||

5302: 'mfg_lookups mlu1, ' ||
5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||
5307: 'mfg_lookups mlu6, ' ||
5308: 'mtl_parameters mtp, ' ||
5309: 'mtl_parameters mpm, ' ||
5310: 'mtl_parameters mpc, ' ||

Line 5307: 'mfg_lookups mlu6, ' ||

5303: 'mfg_lookups mlu2, ' ||
5304: 'mfg_lookups mlu3, ' ||
5305: 'mfg_lookups mlu4, ' ||
5306: 'mfg_lookups mlu5, ' ||
5307: 'mfg_lookups mlu6, ' ||
5308: 'mtl_parameters mtp, ' ||
5309: 'mtl_parameters mpm, ' ||
5310: 'mtl_parameters mpc, ' ||
5311: 'wip_parameters_v wip1, ' ||

Line 5455: mfg_lookups ml

5451: wsfsc.status_move_flag ,
5452: ml.meaning ,
5453: wsfsc.status_move_flag status_move_flag_code
5454: FROM wip_shop_floor_status_codes wsfsc ,
5455: mfg_lookups ml
5456: WHERE ml.lookup_type = 'SYS_YES_NO'
5457: AND ml.lookup_code = wsfsc.status_move_flag
5458: AND organization_id = p_org_id ;
5459:

Line 5547: ' mfg_lookups ml1, ' ||

5543: ' gcc13.concatenated_segments est_scrap_account, ' ||
5544: ' gcc14.concatenated_segments est_scrap_var_account ' ||
5545: ' FROM ' ||
5546: ' wip_accounting_classes wac, ' ||
5547: ' mfg_lookups ml1, ' ||
5548: ' gl_code_combinations_kfv gcc1, ' ||
5549: ' gl_code_combinations_kfv gcc2, ' ||
5550: ' gl_code_combinations_kfv gcc3, ' ||
5551: ' gl_code_combinations_kfv gcc4, ' ||

Line 5612: 'mfg_lookups ml1, ' ||

5608: sqltxt :=
5609: 'SELECT ml1.meaning use_phantom_routings ' ||
5610: ',ml2.meaning inherit_phantom_op_seq ' ||
5611: 'FROM bom_parameters bp, ' ||
5612: 'mfg_lookups ml1, ' ||
5613: 'mfg_lookups ml2 ' ||
5614: 'WHERE bp.organization_id = ' || p_org_id ||
5615: 'AND ml1.lookup_code = bp.use_phantom_routings ' ||
5616: 'AND ml1.lookup_type = ''SYS_YES_NO'' ' ||

Line 5613: 'mfg_lookups ml2 ' ||

5609: 'SELECT ml1.meaning use_phantom_routings ' ||
5610: ',ml2.meaning inherit_phantom_op_seq ' ||
5611: 'FROM bom_parameters bp, ' ||
5612: 'mfg_lookups ml1, ' ||
5613: 'mfg_lookups ml2 ' ||
5614: 'WHERE bp.organization_id = ' || p_org_id ||
5615: 'AND ml1.lookup_code = bp.use_phantom_routings ' ||
5616: 'AND ml1.lookup_type = ''SYS_YES_NO'' ' ||
5617: 'AND ml2.lookup_code = bp.inherit_phantom_op_seq ' ||

Line 5657: 'mfg_lookups ml1, ' ||

5653: 'mar.rule_name, ' ||
5654: 'wl.line_schedule_type ' ||
5655: 'FROM ' ||
5656: 'wip_lines wl, ' ||
5657: 'mfg_lookups ml1, ' ||
5658: 'mtl_atp_rules mar ' ||
5659: 'WHERE ' ||
5660: 'ml1.lookup_code = wl.line_schedule_type AND ' ||
5661: 'ml1.lookup_type = ''WIP_LINE_SCHED_TYPE'' AND ' ||