[Home] [Help]
1183: SUM (ptl.func_tax_amount) func_tax_amount ,
1184: MIN (ptl.delivery_detail_id) delivery_detail_id
1185: FROM
1186: JAI_OM_WSH_LINES_ALL pl ,
1187: JAI_OM_WSH_LINE_TAXES ptl ,
1188: JAI_CMN_TAXES_ALL jtc
1189: WHERE
1190: ptl.delivery_detail_id = pl.delivery_detail_id AND
1191: pl.order_header_id = p_source_document_id AND
1228: SELECT
1229: sum(quantity)
1230: FROM
1231: JAI_OM_WSH_LINES_ALL pl /*,
1232: JAI_OM_WSH_LINE_TAXES ptl*/
1233: WHERE
1234: /*ptl.delivery_detail_id = pl.delivery_detail_id AND*/ /*Commented JAI_OM_WSH_LINE_TAXES and join by mmurtuza for bug 14353666*/
1235: pl.order_header_id = p_source_document_id AND
1236: pl.order_line_id = p_source_document_line_id ;
1230: FROM
1231: JAI_OM_WSH_LINES_ALL pl /*,
1232: JAI_OM_WSH_LINE_TAXES ptl*/
1233: WHERE
1234: /*ptl.delivery_detail_id = pl.delivery_detail_id AND*/ /*Commented JAI_OM_WSH_LINE_TAXES and join by mmurtuza for bug 14353666*/
1235: pl.order_header_id = p_source_document_id AND
1236: pl.order_line_id = p_source_document_line_id ;
1237:
1238: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER)
1745: precedence_7,
1746: precedence_8,
1747: precedence_9,
1748: precedence_10
1749: FROM JAI_OM_WSH_LINE_TAXES sptl,
1750: JAI_CMN_TAXES_ALL jtc
1751: WHERE order_line_id = v_reference_line_id
1752: AND jtc.tax_id = sptl.tax_id)
1753: LOOP
2100: SUM (ptl.func_tax_amount) func_tax_amount ,
2101: MIN (ptl.delivery_detail_id) delivery_detail_id
2102: FROM
2103: JAI_OM_WSH_LINES_ALL pl ,
2104: JAI_OM_WSH_LINE_TAXES ptl ,
2105: JAI_CMN_TAXES_ALL jtc
2106: WHERE
2107: ptl.delivery_detail_id = pl.delivery_detail_id AND
2108: pl.order_header_id = p_source_document_id AND
2145: SELECT
2146: sum(quantity)
2147: FROM
2148: JAI_OM_WSH_LINES_ALL pl /*,
2149: JAI_OM_WSH_LINE_TAXES ptl*/
2150: WHERE
2151: /*ptl.delivery_detail_id = pl.delivery_detail_id AND*/ /*Commented JAI_OM_WSH_LINE_TAXES and join by mmurtuza for bug 14353666*/
2152: pl.order_header_id = p_source_document_id AND
2153: pl.order_line_id = p_source_document_line_id ;
2147: FROM
2148: JAI_OM_WSH_LINES_ALL pl /*,
2149: JAI_OM_WSH_LINE_TAXES ptl*/
2150: WHERE
2151: /*ptl.delivery_detail_id = pl.delivery_detail_id AND*/ /*Commented JAI_OM_WSH_LINE_TAXES and join by mmurtuza for bug 14353666*/
2152: pl.order_header_id = p_source_document_id AND
2153: pl.order_line_id = p_source_document_line_id ;
2154:
2155: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER)
2649: precedence_7,
2650: precedence_8,
2651: precedence_9,
2652: precedence_10
2653: FROM JAI_OM_WSH_LINE_TAXES sptl,
2654: JAI_CMN_TAXES_ALL jtc
2655: WHERE order_line_id = v_reference_line_id
2656: AND jtc.tax_id = sptl.tax_id)
2657: LOOP
3168: ptl.func_tax_amount ,
3169: ptl.delivery_detail_id
3170: FROM
3171: JAI_OM_WSH_LINES_ALL pl ,
3172: JAI_OM_WSH_LINE_TAXES ptl
3173: WHERE
3174: ptl.delivery_detail_id = pl.delivery_detail_id AND
3175: pl.order_header_id = p_source_document_id AND
3176: pl.order_line_id = p_source_document_line_id;
3198: SUM (ptl.func_tax_amount) func_tax_amount ,
3199: MIN (ptl.delivery_detail_id) delivery_detail_id
3200: FROM
3201: JAI_OM_WSH_LINES_ALL pl ,
3202: JAI_OM_WSH_LINE_TAXES ptl
3203: WHERE
3204: ptl.delivery_detail_id = pl.delivery_detail_id AND
3205: pl.order_header_id = p_source_document_id AND
3206: pl.order_line_id = p_source_document_line_id
4213: REM NAME ARIU_T2
4214: REM
4215: REM DESCRIPTION Called from trigger JAI_OE_OLA_ARIUD_T1
4216: REM Populate JAI tables JAI_RGM_INVOICE_GEN_T, JAI_OM_WSH_LINES_ALL,
4217: REM and JAI_OM_WSH_LINE_TAXES for fulfilled non-shippable items.
4218: REM
4219: REM NOTES
4220: REM
4221: REM HISTORY
4322: AND Shippable_Flag = 'N';
4323:
4324: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS
4325: SELECT COUNT(*)
4326: FROM JAI_OM_WSH_LINE_TAXES
4327: WHERE Order_Line_Id = ln_order_line_id
4328: AND Tax_Id = P_Tax_Id;
4329:
4330: CURSOR Get_So_Lines_Details_Cur IS
4345: WHERE Line_id = ln_order_line_id;
4346:
4347: CURSOR Get_Tot_Tax_Amount_Cur IS
4348: SELECT SUM(jowlt.Tax_Amount)
4349: FROM JAI_OM_WSH_LINE_TAXES jowlt
4350: , JAI_CMN_TAXES_ALL jcta
4351: WHERE jowlt.Order_Line_Id = ln_order_line_id
4352: AND jcta.Tax_Id = jowlt.Tax_Id
4353: AND jcta.Tax_Type <> 'TDS';
4361:
4362: CURSOR cur_chk_vat_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)
4363: IS
4364: SELECT 1
4365: FROM JAI_OM_WSH_LINE_TAXES jsptl
4366: , JAI_CMN_TAXES_ALL jtc
4367: , jai_regime_tax_types_v tax_types
4368: WHERE jsptl.order_line_id = cp_order_line_id
4369: AND jtc.tax_id = jsptl.tax_id
4375: SELECT 1
4376: FROM JAI_RGM_INVOICE_GEN_T
4377: WHERE order_line_id = cp_order_line_id;
4378:
4379: -- Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
4380: CURSOR c_chk_vat_reversal (cp_order_line_id JAI_OM_WSH_LINES_ALL.order_line_id%TYPE
4381: , cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
4382: IS
4383: SELECT 1
4380: CURSOR c_chk_vat_reversal (cp_order_line_id JAI_OM_WSH_LINES_ALL.order_line_id%TYPE
4381: , cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
4382: IS
4383: SELECT 1
4384: FROM JAI_OM_WSH_LINE_TAXES jsptl
4385: , JAI_CMN_TAXES_ALL jtc
4386: WHERE jsptl.order_line_id = cp_order_line_id
4387: AND jtc.tax_id = jsptl.tax_id
4388: AND jtc.tax_type = cp_tax_type;
4411: /*CURSOR cur_chk_gst_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE,
4412: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)
4413: IS
4414: SELECT 1
4415: FROM JAI_OM_WSH_LINE_TAXES jsptl
4416: , JAI_CMN_TAXES_ALL jtc
4417: , jai_regime_tax_types_v tax_types
4418: WHERE jsptl.order_line_id = cp_order_line_id
4419: AND jtc.tax_id = jsptl.tax_id
4475:
4476: -- Start Inserting Tax Lines
4477: FOR Rec IN Get_Tax_Lines_Details_Cur
4478: LOOP
4479: -- Check for the existence of Tax Lines on JAI_OM_WSH_LINE_TAXES
4480: OPEN Pick_Tax_Line_Count_Cur(rec.tax_id);
4481: FETCH Pick_Tax_Line_Count_Cur INTO ln_picking_tax_lines_count;
4482: CLOSE Pick_Tax_Line_Count_Cur;
4483: IF ln_picking_tax_lines_count = 0
4481: FETCH Pick_Tax_Line_Count_Cur INTO ln_picking_tax_lines_count;
4482: CLOSE Pick_Tax_Line_Count_Cur;
4483: IF ln_picking_tax_lines_count = 0
4484: THEN
4485: INSERT INTO JAI_OM_WSH_LINE_TAXES(Delivery_Detail_Id
4486: , order_line_id
4487: , Tax_Line_No
4488: , Precedence_1
4489: , Precedence_2
4534: , ln_last_updated_by
4535: , ln_last_update_login
4536: );
4537: ELSE
4538: UPDATE JAI_OM_WSH_LINE_TAXES
4539: SET Tax_Amount = rec.tax_amount,
4540: Last_Update_Date = ld_last_update_date,
4541: Last_Updated_By = ln_last_updated_by,
4542: Last_Update_Login = ln_last_update_login
4692: OPEN cur_chk_vat_proc_entry (cp_order_line_id => ln_order_line_id);
4693: FETCH cur_chk_vat_proc_entry INTO ln_vat_proc_cnt ;
4694: CLOSE cur_chk_vat_proc_entry;
4695:
4696: -- Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
4697: IF nvl(ln_vat_cnt,0) = 0
4698: THEN
4699: -- If taxes of type 'VAT' are not present
4700: lv_vat_reversal := 'VAT REVERSAL' ;