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_ASSIGNMENTS

Line 5970: wsh_delivery_assignments da,

5966: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".Hence split the SQL Query.
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'

Line 6068: wsh_delivery_assignments da,

6064: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".Hence Split the Query.
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'

Line 8876: wsh_delivery_assignments da,

8872: -- Fix for the bug 2196494
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'

Line 8886: wsh_delivery_assignments da,

8882: AND dd.source_line_id is not null
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'

Line 8897: wsh_delivery_assignments da,

8893:
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'

Line 9481: wsh_delivery_assignments da,

9477: --in more than one delivery.Hence used "MIN"instead of "ROWNUM".
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'

Line 9494: wsh_delivery_assignments da,

9490: ELSE
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'

Line 9568: wsh_delivery_assignments da,

9564: l_line_delivery_id := NULL;
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'

Line 9580: wsh_delivery_assignments da,

9576: IF l_line_delivery_id IS NULL AND l_invoice_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
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'

Line 9594: wsh_delivery_assignments da,

9590: l_line_delivery_id := NULL;
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'

Line 9698: wsh_delivery_assignments da,

9694: l_line_delivery_id := NULL;
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'

Line 9710: wsh_delivery_assignments da,

9706: IF l_line_delivery_id IS NULL AND l_line_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
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'

Line 9727: wsh_delivery_assignments da,

9723: IF l_line_rec.item_type_code in ('MODEL', 'CLASS', 'KIT') THEN
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'