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 505: FROM mtl_parameters

501: END;
502:
503: SELECT lot_number_uniqueness
504: INTO l_lotunique
505: FROM mtl_parameters
506: WHERE organization_id = p_organization_id;
507:
508: SELECT lot_status_enabled --Added select for bug4066234
509: INTO l_dest_status_enabled

Line 2463: FROM mtl_parameters

2459: THEN
2460: BEGIN
2461: SELECT lot_number_uniqueness
2462: INTO l_lot_uniqueness
2463: FROM mtl_parameters
2464: WHERE organization_id = p_org_id;
2465: EXCEPTION
2466: WHEN NO_DATA_FOUND
2467: THEN

Line 2825: FROM mtl_parameters

2821: SELECT lot_number_generation,
2822: parent_child_generation_flag,
2823: child_lot_zero_padding_flag,
2824: child_lot_alpha_prefix, NVL(child_lot_number_length,80)
2825: FROM mtl_parameters
2826: WHERE organization_id = p_org_id;
2827:
2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;

Line 2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;

2824: child_lot_alpha_prefix, NVL(child_lot_number_length,80)
2825: FROM mtl_parameters
2826: WHERE organization_id = p_org_id;
2827:
2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;

Line 2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;

2825: FROM mtl_parameters
2826: WHERE organization_id = p_org_id;
2827:
2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2833:

Line 2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;

2826: WHERE organization_id = p_org_id;
2827:
2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2833:
2834: /*======================================

Line 2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;

2827:
2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2833:
2834: /*======================================
2835: x_pad_value is the number of

Line 2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;

2828: x_parent_child_generation_flag MTL_PARAMETERS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2829: x_child_lot_zero_padding_flag MTL_PARAMETERS.CHILD_LOT_ZERO_PADDING_FLAG%TYPE;
2830: x_child_lot_alpha_prefix MTL_PARAMETERS.CHILD_LOT_ALPHA_PREFIX%TYPE;
2831: x_child_lot_number_length MTL_PARAMETERS.CHILD_LOT_NUMBER_LENGTH%TYPE;
2832: x_lot_number_generation MTL_PARAMETERS.LOT_NUMBER_GENERATION%TYPE;
2833:
2834: /*======================================
2835: x_pad_value is the number of
2836: characters to be padded in the child

Line 3344: FROM mtl_parameters

3340: lot_uniqueness,
3341: zero_pad,
3342: lot_length,
3343: lot_prefix
3344: FROM mtl_parameters
3345: WHERE organization_id = p_org_id;
3346: EXCEPTION
3347: WHEN NO_DATA_FOUND THEN
3348: fnd_message.set_name ('INV' , 'INV_FIELD_INVALID' );

Line 3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM

3456:
3457: -- Following query added as a part of the bug fix for Bug # 3330855
3458: SELECT ORGANIZATION_CODE, CONCATENATED_SEGMENTS
3459: INTO v_org_code, v_item_name
3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM
3461: WHERE ORG.ORGANIZATION_ID = p_org_id
3462: AND INVENTORY_ITEM_ID = p_inventory_item_id
3463: AND ITEM.ORGANIZATION_ID = p_org_id;
3464:

Line 3672: FROM mtl_parameters

3668: THEN
3669: BEGIN
3670: SELECT lot_number_uniqueness
3671: INTO l_lot_uniqueness
3672: FROM mtl_parameters
3673: WHERE organization_id = p_org_id;
3674: EXCEPTION
3675: WHEN NO_DATA_FOUND
3676: THEN

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

4461: IF g_debug = 1 THEN
4462: print_debug('Item is lot controlled ', 9);
4463: END IF;
4464:
4465: /* Get the Lot number uniqueness from mtl_parameters for the passed org_id
4466: oNE MESSAGE TO BE ADDED
4467: */
4468: BEGIN
4469: SELECT lot_number_uniqueness

Line 4471: FROM mtl_parameters

4467: */
4468: BEGIN
4469: SELECT lot_number_uniqueness
4470: INTO l_lot_number_uniqueness
4471: FROM mtl_parameters
4472: WHERE organization_id = p_organization_id;
4473: EXCEPTION
4474: WHEN NO_DATA_FOUND THEN
4475: IF (g_debug = 1) THEN

Line 8235: FROM mtl_parameters

8231: SELECT lot_number_generation,
8232: parent_child_generation_flag,
8233: child_lot_alpha_prefix, child_lot_number_length,
8234: child_lot_validation_flag, child_lot_zero_padding_flag
8235: FROM mtl_parameters
8236: WHERE organization_id = p_organization_id;
8237:
8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

Line 8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;

8234: child_lot_validation_flag, child_lot_zero_padding_flag
8235: FROM mtl_parameters
8236: WHERE organization_id = p_organization_id;
8237:
8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;

Line 8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

8235: FROM mtl_parameters
8236: WHERE organization_id = p_organization_id;
8237:
8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;

Line 8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;

8236: WHERE organization_id = p_organization_id;
8237:
8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
8244:

Line 8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;

8237:
8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
8244:
8245: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

Line 8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;

8238: l_prm_lot_number_generation MTL_PARAMETERS.lot_number_generation%TYPE;
8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
8244:
8245: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8246: l_parent_length NUMBER;

Line 8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;

8239: l_prm_parent_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8240: l_prm_child_lot_alpha_prefix MTL_PARAMETERS.child_lot_alpha_prefix%TYPE;
8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
8244:
8245: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8246: l_parent_length NUMBER;
8247: l_child_prefix_length NUMBER;

Line 8245: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;

8241: l_prm_child_lot_number_length MTL_PARAMETERS.child_lot_number_length%TYPE;
8242: l_prm_child_lot_val_flag MTL_PARAMETERS.child_lot_validation_flag%TYPE;
8243: l_prm_zero_padding_flag MTL_PARAMETERS.child_lot_zero_padding_flag%TYPE;
8244:
8245: l_common_child_gen_flag MTL_PARAMETERS.parent_child_generation_flag%TYPE;
8246: l_parent_length NUMBER;
8247: l_child_prefix_length NUMBER;
8248: l_child_prefix VARCHAR2(30);
8249: l_final_start NUMBER;

Line 8308: Get mtl_parameters information.

8304: RAISE fnd_api.g_exc_error;
8305: END IF;
8306:
8307: /*==========================================
8308: Get mtl_parameters information.
8309: ========================================*/
8310:
8311: OPEN get_child_parms;
8312: FETCH get_child_parms INTO

Line 9668: FROM mtl_parameters

9664: /* Cursor definition to check if Lot UOM Conversion is needed */
9665: CURSOR c_lot_uom_conv(cp_organization_id NUMBER) IS
9666: SELECT copy_lot_attribute_flag,
9667: lot_number_generation
9668: FROM mtl_parameters
9669: WHERE organization_id = cp_organization_id;
9670:
9671: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
9672:

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

10026:
10027: IF c_lot_uom_conv%FOUND THEN
10028: CLOSE c_lot_uom_conv ;
10029:
10030: -- Possible values for mtl_parameters.lot_number_generation are:
10031: -- 1 At organization level
10032: -- 3 User defined
10033: -- 2 At item level
10034:

Line 11039: FROM mtl_parameters

11035: END ;
11036:
11037: begin
11038: SELECT create_lot_uom_conversion INTO l_create_lot_uom_conversion
11039: FROM mtl_parameters
11040: WHERE organization_id =p_organization_id ;
11041: EXCEPTION
11042: WHEN No_Data_Found THEN
11043: l_create_lot_uom_conversion:=NULL;