DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on MTL_PARAMETERS

Line 748: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;

744: l_orig_value VARCHAR2(2);
745: l_orig_update_cont_value VARCHAR2(2);
746: l_net_weight number;
747:
748: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
749: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
750: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
751: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
752: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;

Line 749: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;

745: l_orig_update_cont_value VARCHAR2(2);
746: l_net_weight number;
747:
748: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
749: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
750: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
751: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
752: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
753: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;

Line 750: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;

746: l_net_weight number;
747:
748: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
749: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
750: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
751: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
752: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
753: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;
754: l_cont_name_dig number;

Line 751: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;

747:
748: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
749: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
750: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
751: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
752: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
753: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;
754: l_cont_name_dig number;
755: l_tare_wt NUMBER;

Line 774: FROM mtl_parameters

770: SELECT LPN_PREFIX,
771: LPN_SUFFIX,
772: LPN_STARTING_NUMBER ,
773: TOTAL_LPN_LENGTH
774: FROM mtl_parameters
775: WHERE ORGANIZATION_ID = v_organization_id;
776:
777: CURSOR c_get_lpn_info(v_lpn_id NUMBER) IS
778: SELECT gross_weight ,

Line 7871: mtl_parameters mp

7867:
7868: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
7869: SELECT mp.wms_enabled_flag
7870: FROM wsh_new_deliveries wnd,
7871: mtl_parameters mp
7872: WHERE wnd.delivery_id = x_delivery_id
7873: AND mp.organization_id = wnd.organization_id;
7874:
7875: