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 JAI_OM_WSH_LINES_ALL

Line 904: -- get the details from JAI_OM_WSH_LINES_ALL table

900:
901: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
902:
903: DECLARE
904: -- get the details from JAI_OM_WSH_LINES_ALL table
905: CURSOR cur_get_picking_lines(
906: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
907: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
908: )

Line 920: JAI_OM_WSH_LINES_ALL pl

916: pl.selling_price ,
917: pl.tax_amount ,
918: pl.delivery_detail_id
919: FROM
920: JAI_OM_WSH_LINES_ALL pl
921: WHERE
922: pl.order_header_id = p_source_document_id AND
923: pl.order_line_id = p_source_document_line_id ;
924: */

Line 936: JAI_OM_WSH_LINES_ALL pl

932: pl.selling_price selling_price ,
933: sum(pl.tax_amount) tax_amount ,
934: min(pl.delivery_detail_id) delivery_detail_id
935: FROM
936: JAI_OM_WSH_LINES_ALL pl
937: WHERE
938: pl.order_header_id = p_source_document_id AND
939: pl.order_line_id = p_source_document_line_id
940: GROUP BY

Line 978: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

974: /*
975: || Added for bug#5256498, Starts --bduvarag
976: */
977: CURSOR cur_get_picking_tax_lines (
978: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
979: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
980: )
981: IS
982: SELECT

Line 979: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE

975: || Added for bug#5256498, Starts --bduvarag
976: */
977: CURSOR cur_get_picking_tax_lines (
978: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
979: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
980: )
981: IS
982: SELECT
983: ptl.tax_line_no tax_line_no ,

Line 1005: JAI_OM_WSH_LINES_ALL pl ,

1001: SUM (ptl.base_tax_amount) base_tax_amount ,
1002: SUM (ptl.func_tax_amount) func_tax_amount ,
1003: MIN (ptl.delivery_detail_id) delivery_detail_id
1004: FROM
1005: JAI_OM_WSH_LINES_ALL pl ,
1006: JAI_OM_WSH_LINE_TAXES ptl ,
1007: JAI_CMN_TAXES_ALL jtc
1008: WHERE
1009: ptl.delivery_detail_id = pl.delivery_detail_id AND

Line 1043: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,

1039: rma_line_id = p_line_id AND
1040: tax_id = p_tax_id ;
1041:
1042: CURSOR c_get_quantity(
1043: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
1044: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
1045: )
1046: IS
1047: SELECT

Line 1044: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type

1040: tax_id = p_tax_id ;
1041:
1042: CURSOR c_get_quantity(
1043: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
1044: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
1045: )
1046: IS
1047: SELECT
1048: quantity

Line 1050: JAI_OM_WSH_LINES_ALL pl ,

1046: IS
1047: SELECT
1048: quantity
1049: FROM
1050: JAI_OM_WSH_LINES_ALL pl ,
1051: JAI_OM_WSH_LINE_TAXES ptl
1052: WHERE
1053: ptl.delivery_detail_id = pl.delivery_detail_id AND
1054: pl.order_header_id = p_source_document_id AND

Line 1155: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

1151:
1152: lv_check_vat_type_exists VARCHAR2(1);
1153: v_date_ordered DATE;
1154: v_date_confirmed DATE;
1155: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1156: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1157: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1158: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1159: v_excise_flag VARCHAR2(1);

Line 1169: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

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;
1173: v_orig_ord_qty Number;

Line 1172: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
1173: v_orig_ord_qty Number;
1174: v_so_tax_amount Number;
1175: v_rma_quantity_uom VARCHAR2(3);
1176: /*

Line 2013: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

2009:
2010: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
2011: DECLARE
2012: CURSOR cur_get_picking_tax_lines (
2013: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
2014: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
2015: )
2016: IS
2017: /* Commented By Brathod for Bug# 4244829

Line 2014: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE

2010: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
2011: DECLARE
2012: CURSOR cur_get_picking_tax_lines (
2013: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
2014: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
2015: )
2016: IS
2017: /* Commented By Brathod for Bug# 4244829
2018: SELECT

Line 2034: JAI_OM_WSH_LINES_ALL pl ,

2030: ptl.base_tax_amount ,
2031: ptl.func_tax_amount ,
2032: ptl.delivery_detail_id
2033: FROM
2034: JAI_OM_WSH_LINES_ALL pl ,
2035: JAI_OM_WSH_LINE_TAXES ptl
2036: WHERE
2037: ptl.delivery_detail_id = pl.delivery_detail_id AND
2038: pl.order_header_id = p_source_document_id AND

Line 2064: JAI_OM_WSH_LINES_ALL pl ,

2060: SUM (ptl.base_tax_amount) base_tax_amount ,
2061: SUM (ptl.func_tax_amount) func_tax_amount ,
2062: MIN (ptl.delivery_detail_id) delivery_detail_id
2063: FROM
2064: JAI_OM_WSH_LINES_ALL pl ,
2065: JAI_OM_WSH_LINE_TAXES ptl
2066: WHERE
2067: ptl.delivery_detail_id = pl.delivery_detail_id AND
2068: pl.order_header_id = p_source_document_id AND

Line 3479: FROM JAI_OM_WSH_LINES_ALL

3475: v_exist_ship NUMBER; --2002/03/08 Gadde Srinivas
3476:
3477: CURSOR get_count IS
3478: SELECT COUNT(*)
3479: FROM JAI_OM_WSH_LINES_ALL
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