eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INVOICE_PUB dependencies on WSH_DELIVERY_DETAILS

Line 429: FROM WSH_DELIVERY_DETAILS

425: BEGIN
426:
427: SELECT COUNT(*)
428: INTO l_cancelled_delivery_detail
429: FROM WSH_DELIVERY_DETAILS
430: WHERE SOURCE_LINE_ID = p_line_rec.line_id
431: AND SOURCE_CODE='OE'
432: AND RELEASED_STATUS = 'D';
433: IF NVL(l_cancelled_delivery_detail,0) > 0 THEN

Line 5726: wsh_delivery_details dd

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'
5730: AND dd.released_status = 'C' -- bug 6721251

Line 5824: wsh_delivery_details dd

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'
5828: AND dd.released_status = 'C' -- bug 6721251

Line 8463: wsh_delivery_details dd

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'
8467: AND dl.delivery_id = p_delivery_id

Line 8473: wsh_delivery_details dd

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'
8477: AND dl.delivery_id = p_delivery_id

Line 8484: wsh_delivery_details dd

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'
8488: AND dl.delivery_id = p_delivery_id

Line 8922: wsh_delivery_details dd

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'
8926: AND dd.released_status = 'C' -- bug 6721251

Line 8935: wsh_delivery_details dd

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'
8939: AND dd.released_status = 'C' -- bug 6721251

Line 9009: wsh_delivery_details dd

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'
9013: AND dd.released_status = 'C' -- bug 6721251

Line 9021: wsh_delivery_details dd

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'
9025: AND dd.released_status = 'C' -- bug 6721251

Line 9035: wsh_delivery_details dd

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'
9039: AND dd.released_status = 'C' -- bug 6721251

Line 9139: wsh_delivery_details dd

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'
9143: AND dd.released_status = 'C' -- bug 6721251

Line 9151: wsh_delivery_details dd

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'
9155: AND dd.released_status = 'C' -- bug 6721251

Line 9168: wsh_delivery_details dd

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'
9172: AND dd.released_status = 'C' -- bug 6721251