DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 398: Select 'x' from mtl_units_of_measure uom,

394: and cust_account_id = p_ship_to_org_id
395: and location_id= p_ship_to_loc_id;
396:
397: Cursor c_check_volume_uom IS
398: Select 'x' from mtl_units_of_measure uom,
399: wsh_shipping_parameters wsp
400: where wsp.organization_id =p_ship_from_org_id
401: and uom.uom_class = wsp.volume_uom_class
402: and sysdate < nvl(disable_date, sysdate + 1)

Line 406: Select 'x' from mtl_units_of_measure uom,

402: and sysdate < nvl(disable_date, sysdate + 1)
403: and uom_code= p_volume_uom;
404:
405: Cursor c_check_weight_uom IS
406: Select 'x' from mtl_units_of_measure uom,
407: wsh_shipping_parameters wsp
408: where wsp.organization_id =p_ship_from_org_id
409: and uom.uom_class = wsp.weight_uom_class
410: and sysdate < nvl(disable_date, sysdate + 1)

Line 413: Select 'x' from mtl_units_of_measure uom

409: and uom.uom_class = wsp.weight_uom_class
410: and sysdate < nvl(disable_date, sysdate + 1)
411: and uom_code= p_weight_uom;
412: Cursor c_check_uom IS
413: Select 'x' from mtl_units_of_measure uom
414: where sysdate < nvl(disable_date, sysdate + 1)
415: and uom_code= p_uom_code;
416: Cursor c_check_category IS
417: Select 'x' from mtl_categories_b