APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_PARAMETERS

Line 68: FROM mtl_parameters

64: (SELECT mcr.attribute1
65: FROM mtl_cross_references_vl mcr
66: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
67: AND mcr.organization_id = (SELECT master_organization_id
68: FROM mtl_parameters
69: WHERE organization_id = msi.organization_id + 0)
70: AND mcr.cross_reference_type ='OPSM INTEGRATED'
71: AND mcr.cross_reference = 'YES') serial_type,
72: NULL parent_lot_number ,

Line 121: FROM mtl_parameters

117: (SELECT mcr.attribute1
118: FROM mtl_cross_references_vl mcr
119: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
120: AND mcr.organization_id = (SELECT master_organization_id
121: FROM mtl_parameters
122: WHERE organization_id=msi.organization_id+0)
123: AND mcr.cross_reference_type =''OPSM INTEGRATED''
124: AND mcr.cross_reference = ''YES'') serial_type,
125: NULL parent_lot_number ,

Line 180: FROM mtl_parameters

176: (SELECT mcr.attribute1
177: FROM mtl_cross_references_vl mcr
178: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
179: AND mcr.organization_id = (SELECT master_organization_id
180: FROM mtl_parameters
181: WHERE organization_id=msi.organization_id+0)
182: AND mcr.cross_reference_type =''OPSM INTEGRATED''
183: AND mcr.cross_reference = ''YES'') serial_type,
184: NULL parent_lot_number ,

Line 300: FROM mtl_parameters

296: (SELECT mcr.attribute1
297: FROM mtl_cross_references_vl mcr
298: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
299: AND mcr.organization_id = (SELECT master_organization_id
300: FROM mtl_parameters
301: WHERE organization_id = msi.organization_id + 0)
302: AND mcr.cross_reference_type ='OPSM INTEGRATED'
303: AND mcr.cross_reference = 'YES') serial_type
304: FROM wip_entities we ,

Line 473: FROM mtl_parameters

469: g_object_id := NULL;
470: BEGIN
471: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
472: INTO v_wms_enabled
473: FROM mtl_parameters
474: WHERE organization_id = p_organization_id;
475: ----dbms_output.put_line(v_wms_enabled);
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.log(l_module_name, 'WMS_ENABLED_FLAG', v_wms_enabled);

Line 2406: FROM mtl_parameters

2402: (SELECT mcr.attribute1
2403: FROM mtl_cross_references_vl mcr
2404: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2405: AND mcr.organization_id = (SELECT master_organization_id
2406: FROM mtl_parameters
2407: WHERE organization_id = msi.organization_id + 0)
2408: AND mcr.cross_reference_type ='OPSM INTEGRATED'
2409: AND mcr.cross_reference = 'YES') serial_type,
2410: NULL parent_lot_number ,

Line 2459: FROM mtl_parameters

2455: (SELECT mcr.attribute1
2456: FROM mtl_cross_references_vl mcr
2457: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2458: AND mcr.organization_id = (SELECT master_organization_id
2459: FROM mtl_parameters
2460: WHERE organization_id=msi.organization_id+0)
2461: AND mcr.cross_reference_type =''OPSM INTEGRATED''
2462: AND mcr.cross_reference = ''YES'') serial_type,
2463: NULL parent_lot_number ,

Line 2514: FROM mtl_parameters

2510: (SELECT mcr.attribute1
2511: FROM mtl_cross_references_vl mcr
2512: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2513: AND mcr.organization_id = (SELECT master_organization_id
2514: FROM mtl_parameters
2515: WHERE organization_id=msi.organization_id+0)
2516: AND mcr.cross_reference_type =''OPSM INTEGRATED''
2517: AND mcr.cross_reference = ''YES'') serial_type,
2518: NULL parent_lot_number ,

Line 2634: FROM mtl_parameters

2630: (SELECT mcr.attribute1
2631: FROM mtl_cross_references_vl mcr
2632: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2633: AND mcr.organization_id = (SELECT master_organization_id
2634: FROM mtl_parameters
2635: WHERE organization_id = msi.organization_id + 0)
2636: AND mcr.cross_reference_type ='OPSM INTEGRATED'
2637: AND mcr.cross_reference = 'YES') serial_type
2638: FROM wip_entities we ,

Line 2805: FROM mtl_parameters

2801: g_object_id := NULL;
2802: BEGIN
2803: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
2804: INTO v_wms_enabled
2805: FROM mtl_parameters
2806: WHERE organization_id = p_organization_id;
2807: ----dbms_output.put_line(v_wms_enabled);
2808: IF l_debug_on THEN
2809: WSH_DEBUG_SV.log(l_module_name, 'WMS_ENABLED_FLAG', v_wms_enabled);