[Home] [Help]
5721: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".Hence split the SQL Query.
5722: SELECT min(dl.delivery_id)
5723: INTO l_delivery_line_id
5724: FROM wsh_new_deliveries dl,
5725: wsh_delivery_assignments da,
5726: wsh_delivery_details dd
5727: WHERE dd.delivery_detail_id = da.delivery_detail_id
5728: AND da.delivery_id = dl.delivery_id
5729: AND dd.source_code = 'OE'
5819: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".Hence Split the Query.
5820: SELECT min(dl.delivery_id)
5821: INTO l_delivery_line_id
5822: FROM wsh_new_deliveries dl,
5823: wsh_delivery_assignments da,
5824: wsh_delivery_details dd
5825: WHERE dd.delivery_detail_id = da.delivery_detail_id
5826: AND da.delivery_id = dl.delivery_id
5827: AND dd.source_code = 'OE'
8458: -- Fix for the bug 2196494
8459: CURSOR delivery_lines_cursor(p_delivery_id IN NUMBER) IS
8460: SELECT distinct dd.source_line_id
8461: FROM wsh_new_deliveries dl,
8462: wsh_delivery_assignments da,
8463: wsh_delivery_details dd
8464: WHERE dd.delivery_detail_id = da.delivery_detail_id
8465: AND da.delivery_id = dl.delivery_id
8466: AND dd.source_code = 'OE'
8468: AND dd.source_line_id is not null
8469: UNION ALL
8470: SELECT distinct dd.top_model_line_id
8471: FROM wsh_new_deliveries dl,
8472: wsh_delivery_assignments da,
8473: wsh_delivery_details dd
8474: WHERE dd.delivery_detail_id = da.delivery_detail_id
8475: AND da.delivery_id = dl.delivery_id
8476: AND dd.source_code = 'OE'
8479:
8480: CURSOR cur1(p_delivery_id IN NUMBER) IS -- added for 4084965
8481: SELECT 'x'
8482: FROM wsh_new_deliveries dl,
8483: wsh_delivery_assignments da,
8484: wsh_delivery_details dd
8485: WHERE dd.delivery_detail_id = da.delivery_detail_id
8486: AND da.delivery_id = dl.delivery_id
8487: AND dd.source_code = 'OE'
8917: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".
8918: SELECT min(dl.delivery_id)
8919: INTO l_delivery_line_id
8920: FROM wsh_new_deliveries dl,
8921: wsh_delivery_assignments da,
8922: wsh_delivery_details dd
8923: WHERE dd.delivery_detail_id = da.delivery_detail_id
8924: AND da.delivery_id = dl.delivery_id
8925: AND dd.source_code = 'OE'
8930: ELSE
8931: SELECT min(dl.delivery_id)
8932: INTO l_delivery_line_id
8933: FROM wsh_new_deliveries dl,
8934: wsh_delivery_assignments da,
8935: wsh_delivery_details dd
8936: WHERE dd.delivery_detail_id = da.delivery_detail_id
8937: AND da.delivery_id = dl.delivery_id
8938: AND dd.source_code = 'OE'
9004: l_line_delivery_id := NULL;
9005: SELECT min(dl.delivery_id)
9006: INTO l_line_delivery_id
9007: FROM wsh_new_deliveries dl,
9008: wsh_delivery_assignments da,
9009: wsh_delivery_details dd
9010: WHERE dd.delivery_detail_id = da.delivery_detail_id
9011: AND da.delivery_id = dl.delivery_id
9012: AND dd.source_code = 'OE'
9016: IF l_line_delivery_id IS NULL AND l_invoice_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
9017: SELECT min(dl.delivery_id)
9018: INTO l_line_delivery_id
9019: FROM wsh_new_deliveries dl,
9020: wsh_delivery_assignments da,
9021: wsh_delivery_details dd
9022: WHERE dd.delivery_detail_id = da.delivery_detail_id
9023: AND da.delivery_id = dl.delivery_id
9024: AND dd.source_code = 'OE'
9030: l_line_delivery_id := NULL;
9031: SELECT min(dl.delivery_id)
9032: INTO l_line_delivery_id
9033: FROM wsh_new_deliveries dl,
9034: wsh_delivery_assignments da,
9035: wsh_delivery_details dd
9036: WHERE dd.delivery_detail_id = da.delivery_detail_id
9037: AND da.delivery_id = dl.delivery_id
9038: AND dd.source_code = 'OE'
9134: l_line_delivery_id := NULL;
9135: SELECT min(dl.delivery_id)
9136: INTO l_line_delivery_id
9137: FROM wsh_new_deliveries dl,
9138: wsh_delivery_assignments da,
9139: wsh_delivery_details dd
9140: WHERE dd.delivery_detail_id = da.delivery_detail_id
9141: AND da.delivery_id = dl.delivery_id
9142: AND dd.source_code = 'OE'
9146: IF l_line_delivery_id IS NULL AND l_line_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
9147: SELECT min(dl.delivery_id)
9148: INTO l_line_delivery_id
9149: FROM wsh_new_deliveries dl,
9150: wsh_delivery_assignments da,
9151: wsh_delivery_details dd
9152: WHERE dd.delivery_detail_id = da.delivery_detail_id
9153: AND da.delivery_id = dl.delivery_id
9154: AND dd.source_code = 'OE'
9163: IF l_line_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
9164: SELECT min(dl.delivery_id)
9165: INTO l_line_delivery_id
9166: FROM wsh_new_deliveries dl,
9167: wsh_delivery_assignments da,
9168: wsh_delivery_details dd
9169: WHERE dd.delivery_detail_id = da.delivery_detail_id
9170: AND da.delivery_id = dl.delivery_id
9171: AND dd.source_code = 'OE'