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.GML_OPM_ROI_GRP dependencies on DUAL

Line 657: SELECT p_trans_date + l_shelf_life into l_expire_date FROM DUAL ;

653: x_return_status := fnd_api.g_ret_sts_error;
654: RETURN ;
655: ELSIF l_shelf_life_code = 2 THEN
656:
657: SELECT p_trans_date + l_shelf_life into l_expire_date FROM DUAL ;
658:
659: -- if expiration date specified by user is different than system calculated date
660: -- enter record into error table saying expiration date will be over-written.
661:

Line 971: l_dualum_ind NUMBER(1);

967: l_to_um_type VARCHAR2(10);
968: l_to_um_code VARCHAR2(4);
969: l_from_um_type VARCHAR2(10);
970: l_from_um_code VARCHAR2(4);
971: l_dualum_ind NUMBER(1);
972:
973: BEGIN
974:
975: x_return_status := fnd_api.g_ret_sts_success;

Line 1033: -- create lot specific conversion for dual uom item only.

1029: END IF;
1030:
1031: l_progress := '040';
1032:
1033: -- create lot specific conversion for dual uom item only.
1034: IF p_from_unit_of_measure IS NOT NULL AND p_to_unit_of_measure IS NOT NULL THEN
1035: -- check class of from and to uom. call conversion API only if they
1036: -- belong to different class.Also don't create for fixed UOM type(dualum_ind = 1)
1037: -- API requires OPM um_code so fetch OPM um code

Line 1036: -- belong to different class.Also don't create for fixed UOM type(dualum_ind = 1)

1032:
1033: -- create lot specific conversion for dual uom item only.
1034: IF p_from_unit_of_measure IS NOT NULL AND p_to_unit_of_measure IS NOT NULL THEN
1035: -- check class of from and to uom. call conversion API only if they
1036: -- belong to different class.Also don't create for fixed UOM type(dualum_ind = 1)
1037: -- API requires OPM um_code so fetch OPM um code
1038: IF fnd_profile.value('GML_ENABLE_DYN_LOT_SPEC_CONV') = 'Y' THEN
1039:
1040: SELECT um_type , um_code INTO l_from_um_type , l_from_um_code

Line 1050: SELECT dualum_ind INTO l_dualum_ind

1046: SELECT um_type , um_code INTO l_to_um_type , l_to_um_code
1047: FROM SY_UOMS_MST
1048: WHERE unit_of_measure = p_to_unit_of_measure ;
1049:
1050: SELECT dualum_ind INTO l_dualum_ind
1051: FROM IC_ITEM_MST_B
1052: WHERE item_no = l_new_lot_rec.item_no ;
1053:
1054:

Line 1055: IF (l_from_um_type <> l_to_um_type) AND (l_dualum_ind > 1) THEN

1051: FROM IC_ITEM_MST_B
1052: WHERE item_no = l_new_lot_rec.item_no ;
1053:
1054:
1055: IF (l_from_um_type <> l_to_um_type) AND (l_dualum_ind > 1) THEN
1056:
1057: PO_GML_DB_COMMON.CREATE_LOT_SPECIFIC_CONVERSION(
1058: x_item_number => l_new_lot_rec.item_no,
1059: x_lot_number => l_new_lot_rec.lot_no,