eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DIAG_DATA_COLL dependencies on MTL_PARAMETERS

Line 74: ' from wip_discrete_jobs a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||

70: ' decode(a.overcompletion_tolerance_type, ' ||
71: ' 1, ''Percent'', ' ||
72: ' 2, ''Amount'') Tol_Type, ' ||
73: ' a.overcompletion_tolerance_value Tol_Value ' ||
74: ' from wip_discrete_jobs a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||
75: ' where b.wip_entity_id = a.wip_entity_id ' ||
76: ' and b.organization_id = a.organization_id ' ||
77: ' and m.inventory_item_id = a.primary_item_id ' ||
78: ' and m.organization_id = a.organization_id ' ||

Line 2215: 'from wip_repetitive_schedules a , wip_repetitive_items wri, wip_entities b, mtl_system_items m , mtl_parameters p '||

2211: ' a.bom_revision, '||
2212: ' a.routing_revision, '||
2213: ' nvl(a.alternate_bom_designator, ''PRIMARY'') alternate_bom_designator, '||
2214: ' nvl(a.alternate_routing_designator, ''PRIMARY'') alternate_routing_designator '||
2215: 'from wip_repetitive_schedules a , wip_repetitive_items wri, wip_entities b, mtl_system_items m , mtl_parameters p '||
2216: 'where b.wip_entity_id = a.wip_entity_id '||
2217: 'and wri.wip_entity_id = a.wip_entity_id '||
2218: 'and b.organization_id = a.organization_id '||
2219: 'and m.inventory_item_id = b.primary_item_id '||

Line 4090: ' from wip_flow_schedules a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||

4086: ' a.bom_revision, ' ||
4087: ' a.routing_revision, ' ||
4088: ' nvl(a.alternate_bom_designator, ''PRIMARY'') alternate_bom_designator, ' ||
4089: ' nvl(a.alternate_routing_designator, ''PRIMARY'') alternate_routing_designator ' ||
4090: ' from wip_flow_schedules a , wip_entities b, mtl_system_items_kfv m, mtl_parameters p ' ||
4091: ' where b.wip_entity_id = a.wip_entity_id ' ||
4092: ' and b.organization_id = a.organization_id ' ||
4093: ' and m.inventory_item_id = a.primary_item_id ' ||
4094: ' and m.organization_id = a.organization_id ' ||

Line 5027: from mtl_parameters

5023: wip_param_v_rec wip_param_v_csr%ROWTYPE ;
5024:
5025: cursor inv_param_csr is
5026: select *
5027: from mtl_parameters
5028: where organization_id = p_org_id ;
5029:
5030: inv_param_rec inv_param_csr%ROWTYPE ;
5031: apps_ver varchar2(20) ;

Line 5308: 'mtl_parameters mtp, ' ||

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, ' ||
5312: 'wip_parameters wip2, ' ||

Line 5309: 'mtl_parameters mpm, ' ||

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, ' ||
5312: 'wip_parameters wip2, ' ||
5313: 'mtl_item_locations_kfv milk, ' ||

Line 5310: 'mtl_parameters mpc, ' ||

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, ' ||
5312: 'wip_parameters wip2, ' ||
5313: 'mtl_item_locations_kfv milk, ' ||
5314: 'gl_code_combinations_kfv gcck ' ||