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 635: FROM WSH_DELIVERY_DETAILS

631: BEGIN
632:
633: SELECT COUNT(*)
634: INTO l_cancelled_delivery_detail
635: FROM WSH_DELIVERY_DETAILS
636: WHERE SOURCE_LINE_ID = p_line_rec.line_id
637: AND SOURCE_CODE='OE'
638: AND RELEASED_STATUS = 'D';
639: IF NVL(l_cancelled_delivery_detail,0) > 0 THEN

Line 5971: wsh_delivery_details dd

5967: SELECT min(dl.delivery_id)
5968: INTO l_delivery_line_id
5969: FROM wsh_new_deliveries dl,
5970: wsh_delivery_assignments da,
5971: wsh_delivery_details dd
5972: WHERE dd.delivery_detail_id = da.delivery_detail_id
5973: AND da.delivery_id = dl.delivery_id
5974: AND dd.source_code = 'OE'
5975: AND dd.released_status = 'C' -- bug 6721251

Line 6069: wsh_delivery_details dd

6065: SELECT min(dl.delivery_id)
6066: INTO l_delivery_line_id
6067: FROM wsh_new_deliveries dl,
6068: wsh_delivery_assignments da,
6069: wsh_delivery_details dd
6070: WHERE dd.delivery_detail_id = da.delivery_detail_id
6071: AND da.delivery_id = dl.delivery_id
6072: AND dd.source_code = 'OE'
6073: AND dd.released_status = 'C' -- bug 6721251

Line 8877: wsh_delivery_details dd

8873: CURSOR delivery_lines_cursor(p_delivery_id IN NUMBER) IS
8874: SELECT distinct dd.source_line_id
8875: FROM wsh_new_deliveries dl,
8876: wsh_delivery_assignments da,
8877: wsh_delivery_details dd
8878: WHERE dd.delivery_detail_id = da.delivery_detail_id
8879: AND da.delivery_id = dl.delivery_id
8880: AND dd.source_code = 'OE'
8881: AND dl.delivery_id = p_delivery_id

Line 8887: wsh_delivery_details dd

8883: UNION ALL
8884: SELECT distinct dd.top_model_line_id
8885: FROM wsh_new_deliveries dl,
8886: wsh_delivery_assignments da,
8887: wsh_delivery_details dd
8888: WHERE dd.delivery_detail_id = da.delivery_detail_id
8889: AND da.delivery_id = dl.delivery_id
8890: AND dd.source_code = 'OE'
8891: AND dl.delivery_id = p_delivery_id

Line 8898: wsh_delivery_details dd

8894: CURSOR cur1(p_delivery_id IN NUMBER) IS -- added for 4084965
8895: SELECT 'x'
8896: FROM wsh_new_deliveries dl,
8897: wsh_delivery_assignments da,
8898: wsh_delivery_details dd
8899: WHERE dd.delivery_detail_id = da.delivery_detail_id
8900: AND da.delivery_id = dl.delivery_id
8901: AND dd.source_code = 'OE'
8902: AND dl.delivery_id = p_delivery_id

Line 9482: wsh_delivery_details dd

9478: SELECT min(dl.delivery_id)
9479: INTO l_delivery_line_id
9480: FROM wsh_new_deliveries dl,
9481: wsh_delivery_assignments da,
9482: wsh_delivery_details dd
9483: WHERE dd.delivery_detail_id = da.delivery_detail_id
9484: AND da.delivery_id = dl.delivery_id
9485: AND dd.source_code = 'OE'
9486: AND dd.released_status = 'C' -- bug 6721251

Line 9495: wsh_delivery_details dd

9491: SELECT min(dl.delivery_id)
9492: INTO l_delivery_line_id
9493: FROM wsh_new_deliveries dl,
9494: wsh_delivery_assignments da,
9495: wsh_delivery_details dd
9496: WHERE dd.delivery_detail_id = da.delivery_detail_id
9497: AND da.delivery_id = dl.delivery_id
9498: AND dd.source_code = 'OE'
9499: AND dd.released_status = 'C' -- bug 6721251

Line 9569: wsh_delivery_details dd

9565: SELECT min(dl.delivery_id)
9566: INTO l_line_delivery_id
9567: FROM wsh_new_deliveries dl,
9568: wsh_delivery_assignments da,
9569: wsh_delivery_details dd
9570: WHERE dd.delivery_detail_id = da.delivery_detail_id
9571: AND da.delivery_id = dl.delivery_id
9572: AND dd.source_code = 'OE'
9573: AND dd.released_status = 'C' -- bug 6721251

Line 9581: wsh_delivery_details dd

9577: SELECT min(dl.delivery_id)
9578: INTO l_line_delivery_id
9579: FROM wsh_new_deliveries dl,
9580: wsh_delivery_assignments da,
9581: wsh_delivery_details dd
9582: WHERE dd.delivery_detail_id = da.delivery_detail_id
9583: AND da.delivery_id = dl.delivery_id
9584: AND dd.source_code = 'OE'
9585: AND dd.released_status = 'C' -- bug 6721251

Line 9595: wsh_delivery_details dd

9591: SELECT min(dl.delivery_id)
9592: INTO l_line_delivery_id
9593: FROM wsh_new_deliveries dl,
9594: wsh_delivery_assignments da,
9595: wsh_delivery_details dd
9596: WHERE dd.delivery_detail_id = da.delivery_detail_id
9597: AND da.delivery_id = dl.delivery_id
9598: AND dd.source_code = 'OE'
9599: AND dd.released_status = 'C' -- bug 6721251

Line 9699: wsh_delivery_details dd

9695: SELECT min(dl.delivery_id)
9696: INTO l_line_delivery_id
9697: FROM wsh_new_deliveries dl,
9698: wsh_delivery_assignments da,
9699: wsh_delivery_details dd
9700: WHERE dd.delivery_detail_id = da.delivery_detail_id
9701: AND da.delivery_id = dl.delivery_id
9702: AND dd.source_code = 'OE'
9703: AND dd.released_status = 'C' -- bug 6721251

Line 9711: wsh_delivery_details dd

9707: SELECT min(dl.delivery_id)
9708: INTO l_line_delivery_id
9709: FROM wsh_new_deliveries dl,
9710: wsh_delivery_assignments da,
9711: wsh_delivery_details dd
9712: WHERE dd.delivery_detail_id = da.delivery_detail_id
9713: AND da.delivery_id = dl.delivery_id
9714: AND dd.source_code = 'OE'
9715: AND dd.released_status = 'C' -- bug 6721251

Line 9728: wsh_delivery_details dd

9724: SELECT min(dl.delivery_id)
9725: INTO l_line_delivery_id
9726: FROM wsh_new_deliveries dl,
9727: wsh_delivery_assignments da,
9728: wsh_delivery_details dd
9729: WHERE dd.delivery_detail_id = da.delivery_detail_id
9730: AND da.delivery_id = dl.delivery_id
9731: AND dd.source_code = 'OE'
9732: AND dd.released_status = 'C' -- bug 6721251