[Home] [Help]
1467: X_progress := '010';
1468:
1469: SELECT COUNT(1)
1470: INTO X_row_exists
1471: FROM MTL_SUPPLY
1472: WHERE req_header_id = X_req_header_id
1473: AND req_line_id = NVL(X_req_line_id, req_line_id)
1474: AND supply_type_code = 'SHIPMENT'
1475: AND quantity > 0;