APPS.WSH_CONTAINER_ACTIONS dependencies on MTL_PARAMETERS

Line 775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;

771: l_orig_value VARCHAR2(2);
772: l_orig_update_cont_value VARCHAR2(2);
773: l_net_weight number;
774:
775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;

Line 776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;

772: l_orig_update_cont_value VARCHAR2(2);
773: l_net_weight number;
774:
775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
780: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;

Line 777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;

773: l_net_weight number;
774:
775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
780: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;
781: l_cont_name_dig number;

Line 778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;

774:
775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
780: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;
781: l_cont_name_dig number;
782: l_tare_wt NUMBER;

Line 801: FROM mtl_parameters

797: SELECT LPN_PREFIX,
798: LPN_SUFFIX,
799: LPN_STARTING_NUMBER ,
800: TOTAL_LPN_LENGTH
801: FROM mtl_parameters
802: WHERE ORGANIZATION_ID = v_organization_id;
803:
804: CURSOR c_get_lpn_info(v_lpn_id NUMBER) IS
805: SELECT gross_weight ,

Line 8000: mtl_parameters mp

7996:
7997: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
7998: SELECT mp.wms_enabled_flag
7999: FROM wsh_new_deliveries wnd,
8000: mtl_parameters mp
8001: WHERE wnd.delivery_id = x_delivery_id
8002: AND mp.organization_id = wnd.organization_id;
8003:
8004: