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 5724: FROM wsh_new_deliveries dl,

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

Line 5753: FROM wsh_new_deliveries dl

5749: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE3
5750: ,p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE4
5751: ,l_ship_method_code
5752: ,p_x_interface_line_rec.SHIP_DATE_ACTUAL
5753: FROM wsh_new_deliveries dl
5754: WHERE dl.delivery_id = l_delivery_line_id;
5755:
5756: IF l_debug_level > 0 THEN
5757: oe_debug_pub.add( 'POPULATING BILL OF LADING NUMBER ..' , 5 ) ;

Line 5822: FROM wsh_new_deliveries dl,

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

Line 5850: FROM wsh_new_deliveries dl

5846: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE3
5847: ,p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE4
5848: ,l_ship_method_code
5849: ,p_x_interface_line_rec.SHIP_DATE_ACTUAL
5850: FROM wsh_new_deliveries dl
5851: WHERE dl.delivery_id = l_delivery_line_id;
5852:
5853:
5854: IF l_debug_level > 0 THEN

Line 7814: FROM wsh_new_deliveries

7810: WHERE c.column_type = 'M';
7811:
7812: CURSOR cur_get_del_id (p_del_name IN VARCHAR2) IS
7813: SELECT delivery_id
7814: FROM wsh_new_deliveries
7815: WHERE name = p_del_name;
7816: --
7817: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7818: --

Line 8461: FROM wsh_new_deliveries dl,

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

Line 8471: FROM wsh_new_deliveries dl,

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

Line 8482: FROM wsh_new_deliveries dl,

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

Line 8920: FROM wsh_new_deliveries dl,

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

Line 8933: FROM wsh_new_deliveries dl,

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

Line 9007: FROM wsh_new_deliveries dl,

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

Line 9019: FROM wsh_new_deliveries dl,

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

Line 9033: FROM wsh_new_deliveries dl,

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

Line 9072: FROM wsh_new_deliveries dl

9068: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9069: IF l_delivery_line_id Is Not Null Then
9070: SELECT NVL(SUBSTR(dl.name, 1, 30), '0')
9071: INTO l_delivery_name
9072: FROM wsh_new_deliveries dl
9073: WHERE dl.delivery_id = l_delivery_line_id;
9074: END IF;
9075: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9076: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);

Line 9137: FROM wsh_new_deliveries dl,

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

Line 9149: FROM wsh_new_deliveries dl,

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

Line 9166: FROM wsh_new_deliveries dl,

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