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_NEW_DELIVERIES

Line 5969: FROM wsh_new_deliveries dl,

5965: --Bug2181628 TO retrieve the minimum delivery_id of a line,if it is present
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

Line 5998: FROM wsh_new_deliveries dl

5994: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE3
5995: ,p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE4
5996: ,l_ship_method_code
5997: ,p_x_interface_line_rec.SHIP_DATE_ACTUAL
5998: FROM wsh_new_deliveries dl
5999: WHERE dl.delivery_id = l_delivery_line_id;
6000:
6001: IF l_debug_level > 0 THEN
6002: oe_debug_pub.add( 'POPULATING BILL OF LADING NUMBER ..' , 5 ) ;

Line 6067: FROM wsh_new_deliveries dl,

6063: --Bug2181628 TO retrieve the minimum delivery_id of a line,if it is present
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

Line 6095: FROM wsh_new_deliveries dl

6091: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE3
6092: ,p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE4
6093: ,l_ship_method_code
6094: ,p_x_interface_line_rec.SHIP_DATE_ACTUAL
6095: FROM wsh_new_deliveries dl
6096: WHERE dl.delivery_id = l_delivery_line_id;
6097:
6098:
6099: IF l_debug_level > 0 THEN

Line 8198: FROM wsh_new_deliveries

8194: WHERE c.column_type = 'M';
8195:
8196: CURSOR cur_get_del_id (p_del_name IN VARCHAR2) IS
8197: SELECT delivery_id
8198: FROM wsh_new_deliveries
8199: WHERE name = p_del_name;
8200: --
8201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8202: --

Line 8875: FROM wsh_new_deliveries dl,

8871:
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

Line 8885: FROM wsh_new_deliveries dl,

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

Line 8896: FROM wsh_new_deliveries dl,

8892: AND dd.top_model_line_id is not null;
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

Line 9480: FROM wsh_new_deliveries dl,

9476: --Bug2181628 TO retrieve the minimum delivery_id of a line,if it is present
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

Line 9493: FROM wsh_new_deliveries dl,

9489: -- Fix for bug 2196494
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

Line 9567: FROM wsh_new_deliveries dl,

9563: AND (l_invoice_rec.shippable_flag = 'Y') THEN
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

Line 9579: FROM wsh_new_deliveries dl,

9575:
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

Line 9593: FROM wsh_new_deliveries dl,

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

Line 9632: FROM wsh_new_deliveries dl

9628: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9629: IF l_delivery_line_id Is Not Null Then
9630: SELECT NVL(SUBSTR(dl.name, 1, 30), '0')
9631: INTO l_delivery_name
9632: FROM wsh_new_deliveries dl
9633: WHERE dl.delivery_id = l_delivery_line_id;
9634: END IF;
9635: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9636: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);

Line 9697: FROM wsh_new_deliveries dl,

9693: AND (l_line_rec.shippable_flag = 'Y') THEN
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

Line 9709: FROM wsh_new_deliveries dl,

9705:
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

Line 9726: FROM wsh_new_deliveries dl,

9722: ELSE
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