DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on MTL_PARAMETERS

Line 2433: , mtl_parameters mtlp

2429: SELECT wct.*
2430: FROM wms_cartonization_temp wct
2431: , mtl_txn_request_lines mtrl
2432: , mtl_secondary_inventories sub
2433: , mtl_parameters mtlp
2434: WHERE wct.move_order_line_id = mtrl.line_id
2435: AND mtrl.header_id = p_move_order_header_id
2436: AND wct.cartonization_id IS NULL
2437: AND mtlp.organization_id = wct.organization_id

Line 2523: FROM mtl_parameters

2519: , NVL(allocate_serial_flag,'N')
2520: INTO v_cart_value
2521: , l_cartonize_sales_orders
2522: , WMS_CARTNZN_PUB.g_allocate_serial_flag
2523: FROM mtl_parameters
2524: WHERE organization_id = p_org_id;
2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: v_cart_value := NULL;