APPS.INV_PHY_INV_LOVS dependencies on MTL_PARAMETERS

Line 1414: FROM mtl_parameters

1410: -- Get the required information for the local variables
1411: -- Locator control type for the org
1412: SELECT stock_locator_control_code
1413: INTO l_org_locator_type
1414: FROM mtl_parameters
1415: WHERE organization_id = p_organization_id;
1416:
1417: -- Locator control type for the sub
1418: SELECT locator_type

Line 1514: FROM mtl_parameters

1510: -- for OPM get the item cost from OPM costing tables.
1511:
1512: SELECT NVL(process_enabled_flag, 'N')
1513: INTO l_process_enabled_flag
1514: FROM mtl_parameters
1515: WHERE organization_id = p_organization_id;
1516:
1517: IF (l_debug = 1) THEN
1518: print_debug('Process enabled flag : ' || l_process_enabled_flag);

Line 1865: FROM MTL_PARAMETERS

1861: IS
1862: BEGIN
1863: SELECT NVL(SERIAL_NUMBER_TYPE, 0)
1864: INTO x_serial_number_type
1865: FROM MTL_PARAMETERS
1866: WHERE ORGANIZATION_ID = p_organization_id;
1867: EXCEPTION
1868: WHEN NO_DATA_FOUND THEN
1869: x_serial_number_type :=0;

Line 1906: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML

1902: /*Bug7829724-Commeneted locator*/
1903: BEGIN
1904: SELECT 1,MP.ORGANIZATION_CODE,ML.MEANING
1905: INTO l_valid_serial,x_organization_code,x_current_status
1906: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML
1907: WHERE SERIAL_NUMBER like p_serial_num
1908: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1909: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1910: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 1942: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1938: * serial should not exist anywhere
1939: */
1940: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1941: INTO x_organization_code,x_current_status
1942: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1943: WHERE SERIAL_NUMBER like p_serial_num
1944: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1945: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE
1946: AND ML.LOOKUP_TYPE like 'SERIAL_NUM_STATUS'

Line 1955: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1951: * serial should not exist in same org, same item
1952: */
1953: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1954: INTO x_organization_code,x_current_status
1955: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1956: WHERE MSN.SERIAL_NUMBER like p_serial_num
1957: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1958: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1959: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

Line 1974: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1970: BEGIN
1971:
1972: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1973: INTO x_organization_code,x_current_status
1974: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1975: WHERE MSN.SERIAL_NUMBER like p_serial_num
1976: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1977: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1978: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

Line 1994: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1990: * serial should not exist in same org
1991: */
1992: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1993: INTO x_organization_code,x_current_status
1994: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1995: WHERE MSN.SERIAL_NUMBER like p_serial_num
1996: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1997: AND MSN.CURRENT_ORGANIZATION_ID = MP. ORGANIZATION_ID
1998: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

Line 2280: FROM mtl_physical_adjustments mpa, mtl_parameters mp

2276: AND Nvl(wms.lot_number,'@#@#@') = Nvl(msn.lot_number(+),'@#@#@')
2277: AND Nvl(wms.lot_number,'@#@#@') = Nvl(mln.lot_number(+),'@#@#@')
2278: ) mpa_sys,
2279: (SELECT mpa.*
2280: FROM mtl_physical_adjustments mpa, mtl_parameters mp
2281: WHERE mpa.organization_id= mp.organization_id
2282: and mpa.organization_id = p_org_id
2283: AND physical_inventory_id = p_phy_inv_id
2284: AND system_quantity = 0

Line 2333: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

2329: l_prev_subinv mtl_physical_adjustments.subinventory_name%TYPE;
2330: l_prev_loctor mtl_physical_adjustments.locator_id%TYPE;
2331: l_rec_count NUMBER:=0;
2332: l_adj_id mtl_physical_adjustments.adjustment_id%TYPE;
2333: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
2334: l_actual_cost mtl_physical_adjustments.actual_cost%TYPE;
2335:
2336: /* Procedure to log the debug mesages */
2337: PROCEDURE Mydebug (p_msg VARCHAR2)

Line 2610: FROM mtl_parameters

2606: mydebug(' Creating a new adjustment : '||l_adj_id );
2607:
2608: SELECT NVL(process_enabled_flag, 'N')
2609: INTO l_process_enabled_flag
2610: FROM mtl_parameters
2611: WHERE organization_id = p_organization_id;
2612:
2613: Mydebug('Process enabled flag : ' || l_process_enabled_flag);
2614: