APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1062: wsh_delivery_details

1058: IS
1059: SELECT
1060: requested_quantity_uom
1061: FROM
1062: wsh_delivery_details
1063: WHERE
1064: delivery_detail_id = p_delivery_detail_id;
1065:
1066: CURSOR c_check_vat_type_tax_exists (cp_tax_type VARCHAR2)

Line 1092: wsh_delivery_details wdd,

1088: SELECT
1089: wdd.delivery_detail_id,
1090: wnd.confirm_date
1091: FROM
1092: wsh_delivery_details wdd,
1093: wsh_delivery_assignments wda,
1094: wsh_new_deliveries wnd
1095: WHERE
1096: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581

Line 1123: CURSOR c_get_ship_qty(cp_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE)

1119: oe_order_headers_all
1120: WHERE
1121: header_id = pr_new.header_id ;
1122:
1123: CURSOR c_get_ship_qty(cp_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE)
1124: IS
1125: SELECT
1126: SUM(wdd.shipped_quantity) qty
1127: FROM

Line 1128: wsh_delivery_details wdd

1124: IS
1125: SELECT
1126: SUM(wdd.shipped_quantity) qty
1127: FROM
1128: wsh_delivery_details wdd
1129: WHERE
1130: wdd.delivery_detail_id = cp_delivery_detail_id
1131: AND wdd.inventory_item_id = pr_new.inventory_item_id ;
1132:

Line 1168: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

1164: v_round_func NUMBER;
1165: v_tax_total NUMBER;
1166: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1167: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1168: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1169: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1170: v_requested_quantity_uom VARCHAR2(3);
1171: v_conversion_rate NUMBER := 0;
1172: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 3484: get the delivery_detail_id from wsh_delivery_details table

3480: WHERE order_line_id = pr_new.reference_line_id;
3481:
3482: /*
3483: This code has been added by aiyer for the fix of the bug #2855855
3484: get the delivery_detail_id from wsh_delivery_details table
3485: */
3486:
3487: CURSOR cur_get_delivery_detail_id
3488: IS

Line 3492: wsh_delivery_details

3488: IS
3489: SELECT
3490: delivery_detail_id
3491: FROM
3492: wsh_delivery_details
3493: WHERE
3494: source_header_id = pr_new.reference_header_id AND
3495: source_line_id = pr_new.reference_line_id AND
3496: inventory_item_id = pr_new.inventory_item_id AND

Line 3499: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

3495: source_line_id = pr_new.reference_line_id AND
3496: inventory_item_id = pr_new.inventory_item_id AND
3497: shipped_quantity IS NOT NULL;
3498:
3499: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
3500:
3501: -- code added by sriram - bug # 2993645
3502:
3503: Cursor c_ordered_date_cur is

Line 3517: wsh_delivery_details wdd,

3513: cursor c_confirmed_date (p_delivery_Detail_id Number) is
3514: select
3515: confirm_date
3516: FROM
3517: wsh_delivery_details wdd,
3518: wsh_delivery_assignments wda,
3519: wsh_new_deliveries wnd
3520: WHERE
3521: wdd.delivery_detail_id = (p_delivery_Detail_id)

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

3577: /*
3578: This code has been added by aiyer for the fix of the bug #2855855
3579: 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.
3580: IF yes then
3581: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
3582: reference_line_id in this table and populate the pr_new.attibute2 dff field
3583: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'
3584: 3. Populate the context with the following information
3585: if pr_new.return_context pr_new.Context