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.JAI_OE_OLA_TRIGGER_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1243: wsh_delivery_details

1239: IS
1240: SELECT
1241: requested_quantity_uom
1242: FROM
1243: wsh_delivery_details
1244: WHERE
1245: delivery_detail_id = p_delivery_detail_id;
1246:
1247: CURSOR c_check_vat_type_tax_exists (cp_tax_type VARCHAR2)

Line 1273: wsh_delivery_details wdd,

1269: SELECT
1270: wdd.delivery_detail_id,
1271: wnd.confirm_date
1272: FROM
1273: wsh_delivery_details wdd,
1274: wsh_delivery_assignments wda,
1275: wsh_new_deliveries wnd
1276: WHERE
1277: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581

Line 1321: wsh_delivery_details wdd

1317: IS
1318: SELECT
1319: SUM(wdd.shipped_quantity) qty
1320: FROM
1321: wsh_delivery_details wdd
1322: WHERE
1323: wdd.delivery_detail_id in (SELECT delivery_detail_id
1324: FROM JAI_OM_WSH_LINES_ALL
1325: WHERE order_header_id = p_source_document_id

Line 1364: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

1360: v_round_func NUMBER;
1361: v_tax_total NUMBER;
1362: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1363: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1364: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1365: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1366: v_requested_quantity_uom VARCHAR2(3);
1367: v_conversion_rate NUMBER := 0;
1368: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 2160: wsh_delivery_details

2156: IS
2157: SELECT
2158: requested_quantity_uom
2159: FROM
2160: wsh_delivery_details
2161: WHERE
2162: delivery_detail_id = p_delivery_detail_id;
2163:
2164: CURSOR c_check_vat_type_tax_exists (cp_tax_type VARCHAR2)

Line 2190: wsh_delivery_details wdd,

2186: SELECT
2187: wdd.delivery_detail_id,
2188: wnd.confirm_date
2189: FROM
2190: wsh_delivery_details wdd,
2191: wsh_delivery_assignments wda,
2192: wsh_new_deliveries wnd
2193: WHERE
2194: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581

Line 2238: wsh_delivery_details wdd

2234: IS
2235: SELECT
2236: SUM(wdd.shipped_quantity) qty
2237: FROM
2238: wsh_delivery_details wdd
2239: WHERE
2240: wdd.delivery_detail_id in (SELECT delivery_detail_id
2241: FROM JAI_OM_WSH_LINES_ALL
2242: WHERE order_header_id = p_source_document_id

Line 2274: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

2270: v_round_func NUMBER;
2271: v_tax_total NUMBER;
2272: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2273: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2274: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2275: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2276: v_requested_quantity_uom VARCHAR2(3);
2277: v_conversion_rate NUMBER := 0;
2278: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 5590: get the delivery_detail_id from wsh_delivery_details table

5586: WHERE order_line_id = pr_new.reference_line_id;
5587:
5588: /*
5589: This code has been added by aiyer for the fix of the bug #2855855
5590: get the delivery_detail_id from wsh_delivery_details table
5591: */
5592:
5593: CURSOR cur_get_delivery_detail_id
5594: IS

Line 5598: wsh_delivery_details

5594: IS
5595: SELECT
5596: delivery_detail_id
5597: FROM
5598: wsh_delivery_details
5599: WHERE
5600: source_header_id = pr_new.reference_header_id AND
5601: source_line_id = pr_new.reference_line_id AND
5602: inventory_item_id = pr_new.inventory_item_id AND

Line 5605: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

5601: source_line_id = pr_new.reference_line_id AND
5602: inventory_item_id = pr_new.inventory_item_id AND
5603: shipped_quantity IS NOT NULL;
5604:
5605: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
5606:
5607: -- code added by sriram - bug # 2993645
5608:
5609: Cursor c_ordered_date_cur is

Line 5623: wsh_delivery_details wdd,

5619: cursor c_confirmed_date (p_delivery_Detail_id Number) is
5620: select
5621: confirm_date
5622: FROM
5623: wsh_delivery_details wdd,
5624: wsh_delivery_assignments wda,
5625: wsh_new_deliveries wnd
5626: WHERE
5627: wdd.delivery_detail_id = (p_delivery_Detail_id)

Line 5760: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and

5756: /*
5757: This code has been added by aiyer for the fix of the bug #2855855
5758: Before inserting a record in the oe_order_lines_all table for a return order, check if the delivery detail_id i.e pr_new.attribute2 is null.
5759: IF yes then
5760: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
5761: reference_line_id in this table and populate the pr_new.attibute2 dff field
5762: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'
5763: 3. Populate the context with the following information
5764: if pr_new.return_context pr_new.Context