APPS.INV_CYC_LOVS dependencies on MTL_PARAMETERS

Line 3191: FROM mtl_parameters

3187: -- Bug # 2743382
3188:
3189: SELECT negative_inv_receipt_code
3190: INTO l_neg_inv_rcpt_code --Negative Balance 1:Allowed 2:Disallowed
3191: FROM mtl_parameters
3192: WHERE organization_id = l_org_id;
3193:
3194: --4870490
3195: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);

Line 4992: FROM mtl_parameters

4988: l_no_of_rows NUMBER;
4989:
4990: CURSOR get_process_enabled_flag IS
4991: SELECT NVL(process_enabled_flag, 'N')
4992: FROM mtl_parameters
4993: WHERE organization_id = l_organization_id;
4994: --End Bug 9650524
4995:
4996: BEGIN

Line 5057: mtl_parameters mp

5053: BEGIN
5054: SELECT NVL ( ccicv.item_cost, 0 )
5055: INTO l_item_cost
5056: FROM cst_cg_item_costs_view ccicv,
5057: mtl_parameters mp
5058: WHERE l_locator_id IS NULL
5059: AND ccicv.organization_id = in_org_id
5060: AND ccicv.inventory_item_id = in_item_id
5061: AND ccicv.organization_id = mp.organization_id

Line 5078: mtl_parameters mp

5074: UNION ALL
5075: SELECT NVL ( ccicv.item_cost, 0 )
5076: FROM mtl_item_locations mil,
5077: cst_cg_item_costs_view ccicv,
5078: mtl_parameters mp
5079: WHERE l_locator_id IS NOT NULL
5080: AND mil.organization_id = in_org_id
5081: AND mil.inventory_location_id = l_locator_id
5082: AND mil.project_id IS NULL

Line 5103: mtl_parameters mp

5099: SELECT NVL ( ccicv.item_cost, 0 )
5100: FROM mtl_item_locations mil,
5101: mrp_project_parameters mrp,
5102: cst_cg_item_costs_view ccicv,
5103: mtl_parameters mp
5104: WHERE l_locator_id IS NOT NULL
5105: AND mil.organization_id = in_org_id
5106: AND mil.inventory_location_id = l_locator_id
5107: AND mil.project_id IS NOT NULL

Line 6227: FROM MTL_PARAMETERS

6223: ELSE
6224: IF ( l_org_id IS NOT NULL ) THEN
6225: SELECT SERIAL_NUMBER_TYPE
6226: INTO l_serial_number_type
6227: FROM MTL_PARAMETERS
6228: WHERE ORGANIZATION_ID = l_org_id;
6229: END IF;
6230:
6231: IF ( l_debug = 1 ) THEN

Line 6599: FROM mtl_parameters

6595: -- Bug # 2743382
6596:
6597: SELECT negative_inv_receipt_code
6598: INTO l_neg_inv_rcpt_code --Negative Balance 1:Allowed 2:Disallowed
6599: FROM mtl_parameters
6600: WHERE organization_id = l_org_id;
6601:
6602: --4870490
6603: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);

Line 7916: FROM mtl_parameters

7912: -- If there is no default at the sub level, get it at the org level
7913: IF ( l_default_cost_group_id IS NULL ) THEN
7914: SELECT NVL ( default_cost_group_id, -999 )
7915: INTO l_default_cost_group_id
7916: FROM mtl_parameters
7917: WHERE organization_id = p_organization_id;
7918: END IF;
7919:
7920: -- Set the out parameters

Line 10107: l_organization_code mtl_parameters.organization_code%TYPE;

10103: serial_unique_exp EXCEPTION;
10104: l_current_organization_id mtl_serial_numbers.current_organization_id%TYPE;
10105: l_inventory_item_id mtl_serial_numbers.inventory_item_id%TYPE;
10106: l_current_status mtl_serial_numbers.current_status%TYPE;
10107: l_organization_code mtl_parameters.organization_code%TYPE;
10108: l_serial_number_type mtl_parameters.serial_number_type%TYPE;
10109: l_exp_case NUMBER;
10110: l_nothing VARCHAR2(1);
10111:

Line 10108: l_serial_number_type mtl_parameters.serial_number_type%TYPE;

10104: l_current_organization_id mtl_serial_numbers.current_organization_id%TYPE;
10105: l_inventory_item_id mtl_serial_numbers.inventory_item_id%TYPE;
10106: l_current_status mtl_serial_numbers.current_status%TYPE;
10107: l_organization_code mtl_parameters.organization_code%TYPE;
10108: l_serial_number_type mtl_parameters.serial_number_type%TYPE;
10109: l_exp_case NUMBER;
10110: l_nothing VARCHAR2(1);
10111:
10112: CURSOR c_serials ( p_fserial_num VARCHAR2 ) IS

Line 10114: FROM mtl_serial_numbers msn,mtl_parameters mp

10110: l_nothing VARCHAR2(1);
10111:
10112: CURSOR c_serials ( p_fserial_num VARCHAR2 ) IS
10113: SELECT msn.current_organization_id, msn.inventory_item_id, msn.current_status, mp.organization_code
10114: FROM mtl_serial_numbers msn,mtl_parameters mp
10115: WHERE msn.serial_number = p_fserial_num
10116: AND msn.current_organization_id IS NOT NULL
10117: AND msn.inventory_item_id IS NOT NULL
10118: AND msn.current_organization_id = mp.organization_id;

Line 10132: FROM MTL_SERIAL_NUMBERS S, MTL_PARAMETERS P

10128:
10129: BEGIN
10130: SELECT 'x'
10131: INTO l_nothing
10132: FROM MTL_SERIAL_NUMBERS S, MTL_PARAMETERS P
10133: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
10134: AND S.SERIAL_NUMBER = p_from_serial
10135: AND P.SERIAL_NUMBER_TYPE = 3
10136: AND P.ORGANIZATION_ID <> p_organization_id;