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.INV_LOT_API_PUB dependencies on MTL_PARAMETERS

Line 394: FROM mtl_parameters

390: END;
391:
392: SELECT lot_number_uniqueness
393: INTO l_lotunique
394: FROM mtl_parameters
395: WHERE organization_id = p_organization_id;
396:
397: SELECT lot_status_enabled --Added select for bug4066234
398: INTO l_dest_status_enabled

Line 2344: FROM mtl_parameters

2340: THEN
2341: BEGIN
2342: SELECT lot_number_uniqueness
2343: INTO l_lot_uniqueness
2344: FROM mtl_parameters
2345: WHERE organization_id = p_org_id;
2346: EXCEPTION
2347: WHEN NO_DATA_FOUND
2348: THEN

Line 2678: FROM mtl_parameters

2674: SELECT lot_number_generation,
2675: parent_child_generation_flag,
2676: child_lot_zero_padding_flag,
2677: child_lot_alpha_prefix, NVL(child_lot_number_length,80)
2678: FROM mtl_parameters
2679: WHERE organization_id = p_org_id;
2680:
2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;

Line 2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;

2677: child_lot_alpha_prefix, NVL(child_lot_number_length,80)
2678: FROM mtl_parameters
2679: WHERE organization_id = p_org_id;
2680:
2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;

Line 2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;

2678: FROM mtl_parameters
2679: WHERE organization_id = p_org_id;
2680:
2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2686:

Line 2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;

2679: WHERE organization_id = p_org_id;
2680:
2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2686:
2687: /*======================================

Line 2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;

2680:
2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2686:
2687: /*======================================
2688: x_pad_value is the number of

Line 2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;

2681: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2682: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2683: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2684: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2685: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2686:
2687: /*======================================
2688: x_pad_value is the number of
2689: characters to be padded in the child

Line 3185: FROM mtl_parameters

3181: lot_uniqueness,
3182: zero_pad,
3183: lot_length,
3184: lot_prefix
3185: FROM mtl_parameters
3186: WHERE organization_id = p_org_id;
3187: EXCEPTION
3188: WHEN NO_DATA_FOUND THEN
3189: fnd_message.set_name ('INV' , 'INV_FIELD_INVALID' );

Line 3301: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM

3297:
3298: -- Following query added as a part of the bug fix for Bug # 3330855
3299: SELECT ORGANIZATION_CODE, CONCATENATED_SEGMENTS
3300: INTO v_org_code, v_item_name
3301: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM
3302: WHERE ORG.ORGANIZATION_ID = p_org_id
3303: AND INVENTORY_ITEM_ID = p_inventory_item_id
3304: AND ITEM.ORGANIZATION_ID = p_org_id;
3305:

Line 3513: FROM mtl_parameters

3509: THEN
3510: BEGIN
3511: SELECT lot_number_uniqueness
3512: INTO l_lot_uniqueness
3513: FROM mtl_parameters
3514: WHERE organization_id = p_org_id;
3515: EXCEPTION
3516: WHEN NO_DATA_FOUND
3517: THEN

Line 4306: /* Get the Lot number uniqueness from mtl_parameters for the passed org_id

4302: IF g_debug = 1 THEN
4303: print_debug('Item is lot controlled ', 9);
4304: END IF;
4305:
4306: /* Get the Lot number uniqueness from mtl_parameters for the passed org_id
4307: oNE MESSAGE TO BE ADDED
4308: */
4309: BEGIN
4310: SELECT lot_number_uniqueness

Line 4312: FROM mtl_parameters

4308: */
4309: BEGIN
4310: SELECT lot_number_uniqueness
4311: INTO l_lot_number_uniqueness
4312: FROM mtl_parameters
4313: WHERE organization_id = p_organization_id;
4314: EXCEPTION
4315: WHEN NO_DATA_FOUND THEN
4316: IF (g_debug = 1) THEN

Line 7882: FROM mtl_parameters

7878: SELECT lot_number_generation,
7879: parent_child_generation_flag,
7880: child_lot_alpha_prefix, child_lot_number_length,
7881: child_lot_validation_flag, child_lot_zero_padding_flag
7882: FROM mtl_parameters
7883: WHERE organization_id = p_organization_id;
7884:
7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

Line 7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;

7881: child_lot_validation_flag, child_lot_zero_padding_flag
7882: FROM mtl_parameters
7883: WHERE organization_id = p_organization_id;
7884:
7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;

Line 7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

7882: FROM mtl_parameters
7883: WHERE organization_id = p_organization_id;
7884:
7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;

Line 7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;

7883: WHERE organization_id = p_organization_id;
7884:
7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
7891:

Line 7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;

7884:
7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
7891:
7892: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

Line 7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;

7885: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
7891:
7892: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7893: l_parent_length NUMBER;

Line 7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;

7886: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7887: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
7891:
7892: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7893: l_parent_length NUMBER;
7894: l_child_prefix_length NUMBER;

Line 7892: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

7888: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
7889: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
7890: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
7891:
7892: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
7893: l_parent_length NUMBER;
7894: l_child_prefix_length NUMBER;
7895: l_child_prefix VARCHAR2(30);
7896: l_final_start NUMBER;

Line 7955: Get mtl_parameters information.

7951: RAISE fnd_api.g_exc_error;
7952: END IF;
7953:
7954: /*==========================================
7955: Get mtl_parameters information.
7956: ========================================*/
7957:
7958: OPEN get_child_parms;
7959: FETCH get_child_parms INTO

Line 9206: FROM mtl_parameters

9202: /* Cursor definition to check if Lot UOM Conversion is needed */
9203: CURSOR c_lot_uom_conv(cp_organization_id NUMBER) IS
9204: SELECT copy_lot_attribute_flag,
9205: lot_number_generation
9206: FROM mtl_parameters
9207: WHERE organization_id = cp_organization_id;
9208:
9209: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
9210:

Line 9560: -- Possible values for mtl_parameters.lot_number_generation are:

9556:
9557: IF c_lot_uom_conv%FOUND THEN
9558: CLOSE c_lot_uom_conv ;
9559:
9560: -- Possible values for mtl_parameters.lot_number_generation are:
9561: -- 1 At organization level
9562: -- 3 User defined
9563: -- 2 At item level
9564: