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_OM_TAX_PROCESSING_PKG dependencies on WSH_DELIVERY_DETAILS

Line 52: ln_ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%type;

48: v_exe_flag VARCHAR2(150);
49: v_mod_flag VARCHAR2(150);
50: v_container_item_flag mtl_system_items.container_item_flag%type;
51: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type;
52: ln_ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%type;
53:
54: /* variables used in debug package */
55: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
56: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;

Line 1201: FROM wsh_delivery_details

1197: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1198:
1199: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER) IS
1200: SELECT requested_quantity_uom
1201: FROM wsh_delivery_details
1202: WHERE delivery_detail_id = p_delivery_detail_id;
1203:
1204: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1205: SELECT 1

Line 1221: FROM wsh_delivery_details wdd,

1217: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
1218:
1219: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1220: SELECT wdd.delivery_detail_id, wnd.confirm_date
1221: FROM wsh_delivery_details wdd,
1222: wsh_delivery_assignments wda,
1223: wsh_new_deliveries wnd
1224: WHERE wdd.delivery_detail_id = p_ddetail_id
1225: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1252: FROM wsh_delivery_details wdd

1248:
1249: CURSOR c_get_ship_qty(p_source_document_id NUMBER,
1250: p_source_document_line_id NUMBER) IS
1251: SELECT SUM(wdd.shipped_quantity) qty
1252: FROM wsh_delivery_details wdd
1253: WHERE wdd.delivery_detail_id in
1254: (SELECT delivery_detail_id
1255: FROM JAI_OM_WSH_LINES_ALL
1256: WHERE order_header_id = p_source_document_id

Line 1328: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

1324: v_round_func NUMBER;
1325: v_tax_total NUMBER;
1326: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1327: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1328: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1329: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1330: v_requested_quantity_uom VARCHAR2(3);
1331: v_conversion_rate NUMBER := 0;
1332: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 1957: FROM wsh_delivery_details

1953: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1954:
1955: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER) IS
1956: SELECT requested_quantity_uom
1957: FROM wsh_delivery_details
1958: WHERE delivery_detail_id = p_delivery_detail_id;
1959:
1960: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1961: SELECT 1

Line 1977: FROM wsh_delivery_details wdd,

1973: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
1974:
1975: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type) IS
1976: SELECT wdd.delivery_detail_id, wnd.confirm_date
1977: FROM wsh_delivery_details wdd,
1978: wsh_delivery_assignments wda,
1979: wsh_new_deliveries wnd
1980: WHERE wdd.delivery_detail_id = p_ddetail_id
1981: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 2008: FROM wsh_delivery_details wdd

2004:
2005: CURSOR c_get_ship_qty(p_source_document_id NUMBER,
2006: p_source_document_line_id NUMBER) IS
2007: SELECT SUM(wdd.shipped_quantity) qty
2008: FROM wsh_delivery_details wdd
2009: WHERE wdd.delivery_detail_id in
2010: (SELECT delivery_detail_id
2011: FROM JAI_OM_WSH_LINES_ALL
2012: WHERE order_header_id = p_source_document_id

Line 2032: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

2028: v_round_func NUMBER;
2029: v_tax_total NUMBER;
2030: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2031: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2032: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2033: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2034: v_requested_quantity_uom VARCHAR2(3);
2035: v_conversion_rate NUMBER := 0;
2036: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 4492: get the delivery_detail_id from wsh_delivery_details table

4488: FROM JAI_OM_WSH_LINES_ALL
4489: WHERE order_line_id = pr_new.reference_line_id;
4490:
4491: /*
4492: get the delivery_detail_id from wsh_delivery_details table
4493: */
4494:
4495: CURSOR cur_get_delivery_detail_id IS
4496: SELECT delivery_detail_id

Line 4497: FROM wsh_delivery_details

4493: */
4494:
4495: CURSOR cur_get_delivery_detail_id IS
4496: SELECT delivery_detail_id
4497: FROM wsh_delivery_details
4498: WHERE source_header_id = pr_new.reference_header_id
4499: AND source_line_id = pr_new.reference_line_id
4500: AND inventory_item_id = pr_new.inventory_item_id
4501: AND shipped_quantity IS NOT NULL;

Line 4503: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

4499: AND source_line_id = pr_new.reference_line_id
4500: AND inventory_item_id = pr_new.inventory_item_id
4501: AND shipped_quantity IS NOT NULL;
4502:
4503: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
4504:
4505: Cursor c_ordered_date_cur is
4506: select ordered_date
4507: from oe_order_headers_all

Line 4514: FROM wsh_delivery_details wdd,

4510: -- following cursor is used to get the ship confirm date based on the delivery detail id
4511:
4512: cursor c_confirmed_date(p_delivery_Detail_id Number) is
4513: select confirm_date
4514: FROM wsh_delivery_details wdd,
4515: wsh_delivery_assignments wda,
4516: wsh_new_deliveries wnd
4517: WHERE wdd.delivery_detail_id = (p_delivery_Detail_id)
4518: AND wda.delivery_detail_id = wdd.delivery_detail_id

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

4615:
4616: /*
4617: 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.
4618: IF yes then
4619: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
4620: reference_line_id in this table and populate the pr_new.attibute2 dff field
4621: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'
4622: 3. Populate the context with the following information
4623: if pr_new.return_context pr_new.Context