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 1085: -- get the details from JAI_OM_WSH_LINES_ALL table

1081:
1082: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
1083:
1084: DECLARE
1085: -- get the details from JAI_OM_WSH_LINES_ALL table
1086: CURSOR cur_get_picking_lines(
1087: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
1088: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
1089: )

Line 1101: JAI_OM_WSH_LINES_ALL pl

1097: pl.selling_price ,
1098: pl.tax_amount ,
1099: pl.delivery_detail_id
1100: FROM
1101: JAI_OM_WSH_LINES_ALL pl
1102: WHERE
1103: pl.order_header_id = p_source_document_id AND
1104: pl.order_line_id = p_source_document_line_id ;
1105: */

Line 1117: JAI_OM_WSH_LINES_ALL pl

1113: pl.selling_price selling_price ,
1114: sum(pl.tax_amount) tax_amount ,
1115: min(pl.delivery_detail_id) delivery_detail_id
1116: FROM
1117: JAI_OM_WSH_LINES_ALL pl
1118: WHERE
1119: pl.order_header_id = p_source_document_id AND
1120: pl.order_line_id = p_source_document_line_id
1121: GROUP BY

Line 1159: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

1155: /*
1156: || Added for bug#5256498, Starts --bduvarag
1157: */
1158: CURSOR cur_get_picking_tax_lines (
1159: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
1160: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
1161: )
1162: IS
1163: SELECT

Line 1160: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE

1156: || Added for bug#5256498, Starts --bduvarag
1157: */
1158: CURSOR cur_get_picking_tax_lines (
1159: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
1160: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
1161: )
1162: IS
1163: SELECT
1164: ptl.tax_line_no tax_line_no ,

Line 1186: JAI_OM_WSH_LINES_ALL pl ,

1182: SUM (ptl.base_tax_amount) base_tax_amount ,
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

Line 1224: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,

1220: rma_line_id = p_line_id AND
1221: tax_id = p_tax_id ;
1222: /*Bug 14039657 - Added sum clause*/
1223: CURSOR c_get_quantity(
1224: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
1225: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
1226: )
1227: IS
1228: SELECT

Line 1225: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type

1221: tax_id = p_tax_id ;
1222: /*Bug 14039657 - Added sum clause*/
1223: CURSOR c_get_quantity(
1224: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
1225: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
1226: )
1227: IS
1228: SELECT
1229: sum(quantity)

Line 1231: JAI_OM_WSH_LINES_ALL pl /*,

1227: IS
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

Line 1310: JAI_OM_WSH_LINES_ALL

1306: IS
1307: SELECT
1308: CREATION_DATE
1309: FROM
1310: JAI_OM_WSH_LINES_ALL
1311: WHERE ORDER_LINE_ID = v_reference_line_id
1312: AND SHIPPABLE_FLAG = 'N';
1313: -- added by Allen Yang for bug 9691880 10-May-2010, end
1314:

Line 1324: FROM JAI_OM_WSH_LINES_ALL

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
1326: and order_line_id = p_source_document_line_id)
1327: AND wdd.inventory_item_id = pr_new.inventory_item_id ;
1328:

Line 1351: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

1347:
1348: lv_check_vat_type_exists VARCHAR2(1);
1349: v_date_ordered DATE;
1350: v_date_confirmed DATE;
1351: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1352: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1353: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1354: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1355: v_excise_flag VARCHAR2(1);

Line 1365: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

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

Line 1368: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
1369: v_orig_ord_qty Number;
1370: v_so_tax_amount Number;
1371: v_rma_quantity_uom VARCHAR2(3);
1372: /*

Line 2028: -- get the details from JAI_OM_WSH_LINES_ALL table

2024: SELECT order_number
2025: FROM oe_order_headers_all
2026: WHERE header_id = cp_rma_header_id;
2027:
2028: -- get the details from JAI_OM_WSH_LINES_ALL table
2029: CURSOR cur_get_picking_lines(
2030: p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE ,
2031: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE
2032: )

Line 2043: JAI_OM_WSH_LINES_ALL pl

2039: pl.selling_price selling_price ,
2040: sum(pl.tax_amount) tax_amount ,
2041: min(pl.delivery_detail_id) delivery_detail_id
2042: FROM
2043: JAI_OM_WSH_LINES_ALL pl
2044: WHERE
2045: pl.order_header_id = p_source_document_id AND
2046: pl.order_line_id = p_source_document_line_id
2047: GROUP BY

Line 2076: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

2072:
2073: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
2074:
2075: CURSOR cur_get_picking_tax_lines (
2076: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
2077: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
2078: )
2079: IS
2080: SELECT

Line 2077: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE

2073: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
2074:
2075: CURSOR cur_get_picking_tax_lines (
2076: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
2077: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
2078: )
2079: IS
2080: SELECT
2081: ptl.tax_line_no tax_line_no ,

Line 2103: JAI_OM_WSH_LINES_ALL pl ,

2099: SUM (ptl.base_tax_amount) base_tax_amount ,
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

Line 2141: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,

2137: rma_line_id = p_line_id AND
2138: tax_id = p_tax_id ;
2139: /*Bug 14039657 - Added sum clause*/
2140: CURSOR c_get_quantity(
2141: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
2142: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
2143: )
2144: IS
2145: SELECT

Line 2142: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type

2138: tax_id = p_tax_id ;
2139: /*Bug 14039657 - Added sum clause*/
2140: CURSOR c_get_quantity(
2141: p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type ,
2142: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type
2143: )
2144: IS
2145: SELECT
2146: sum(quantity)

Line 2148: JAI_OM_WSH_LINES_ALL pl /*,

2144: IS
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

Line 2227: JAI_OM_WSH_LINES_ALL

2223: IS
2224: SELECT
2225: CREATION_DATE
2226: FROM
2227: JAI_OM_WSH_LINES_ALL
2228: WHERE ORDER_LINE_ID = v_reference_line_id
2229: AND SHIPPABLE_FLAG = 'N';
2230: -- added by Allen Yang for bug 9691880 10-May-2010, end
2231:

Line 2241: FROM JAI_OM_WSH_LINES_ALL

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
2243: and order_line_id = p_source_document_line_id)
2244: AND wdd.inventory_item_id = pr_new.inventory_item_id ;
2245:

Line 2261: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

2257:
2258: lv_check_vat_type_exists VARCHAR2(1);
2259: v_date_ordered DATE;
2260: v_date_confirmed DATE;
2261: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2262: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2263: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2264: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2265: v_excise_flag VARCHAR2(1);

Line 2275: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

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

Line 2278: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
2279: v_orig_ord_qty Number;
2280: v_so_tax_amount Number;
2281: v_rma_quantity_uom VARCHAR2(3);
2282: /*

Line 3150: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

3146:
3147: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
3148: DECLARE
3149: CURSOR cur_get_picking_tax_lines (
3150: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
3151: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
3152: )
3153: IS
3154: /* Commented By Brathod for Bug# 4244829

Line 3151: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE

3147: ELSIF v_source_order_category_code = 'ORDER' AND v_line_category_code = 'RETURN' THEN
3148: DECLARE
3149: CURSOR cur_get_picking_tax_lines (
3150: p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
3151: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE
3152: )
3153: IS
3154: /* Commented By Brathod for Bug# 4244829
3155: SELECT

Line 3171: JAI_OM_WSH_LINES_ALL pl ,

3167: ptl.base_tax_amount ,
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

Line 3201: JAI_OM_WSH_LINES_ALL pl ,

3197: SUM (ptl.base_tax_amount) base_tax_amount ,
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

Line 4216: REM Populate JAI tables JAI_RGM_INVOICE_GEN_T, JAI_OM_WSH_LINES_ALL,

4212: REM +======================================================================+
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

Line 4269: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;

4265:
4266: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
4267: /*ln_gst_assessable_value JAI_OM_OE_SO_LINES.GST_ASSESSABLE_VALUE%TYPE;*/ --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
4268:
4269: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
4270: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
4271: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
4273:

Line 4270: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;

4266: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
4267: /*ln_gst_assessable_value JAI_OM_OE_SO_LINES.GST_ASSESSABLE_VALUE%TYPE;*/ --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
4268:
4269: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
4270: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
4271: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
4273:
4274: ln_vat_cnt NUMBER DEFAULT 0 ;

Line 4271: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;

4267: /*ln_gst_assessable_value JAI_OM_OE_SO_LINES.GST_ASSESSABLE_VALUE%TYPE;*/ --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
4268:
4269: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
4270: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
4271: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
4273:
4274: ln_vat_cnt NUMBER DEFAULT 0 ;
4275: ln_vat_proc_cnt NUMBER DEFAULT 0 ;

Line 4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

4268:
4269: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
4270: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
4271: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
4272: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;
4273:
4274: ln_vat_cnt NUMBER DEFAULT 0 ;
4275: ln_vat_proc_cnt NUMBER DEFAULT 0 ;
4276: ln_regime_id JAI_RGM_ORG_REGNS_V.REGIME_ID%TYPE;

Line 4320: FROM JAI_OM_WSH_LINES_ALL

4316: ORDER BY joost.Tax_Line_No;
4317:
4318: CURSOR Get_Fulfill_Line_Count_Cur IS
4319: SELECT COUNT(*)
4320: FROM JAI_OM_WSH_LINES_ALL
4321: WHERE Order_Line_Id = ln_order_line_id
4322: AND Shippable_Flag = 'N';
4323:
4324: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS

Line 4362: CURSOR cur_chk_vat_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)

4358: FROM JAI_INV_SUBINV_DTLS
4359: WHERE Sub_Inventory_Name = lv_subinventory
4360: AND organization_id = ln_organization_Id;
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

Line 4373: CURSOR cur_chk_vat_proc_entry (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)

4369: AND jtc.tax_id = jsptl.tax_id
4370: AND jtc.tax_type = tax_types.tax_type
4371: AND tax_types.regime_code = jai_constants.vat_regime;
4372:
4373: CURSOR cur_chk_vat_proc_entry (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)
4374: IS
4375: SELECT 1
4376: FROM JAI_RGM_INVOICE_GEN_T
4377: WHERE order_line_id = cp_order_line_id;

Line 4380: CURSOR c_chk_vat_reversal (cp_order_line_id JAI_OM_WSH_LINES_ALL.order_line_id%TYPE

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
4384: FROM JAI_OM_WSH_LINE_TAXES jsptl

Line 4411: /*CURSOR cur_chk_gst_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE,

4407: WHERE header_id = ln_order_header_id;
4408:
4409: --Added by Bo Li for bug#10043656 Begin
4410: --------------------------------------------------
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

Line 4569: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.

4565: /*, ln_gst_assessable_value*/; --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
4566: CLOSE Get_So_Lines_Details_Cur;
4567:
4568: -- Get Total Tax Amount for the Line
4569: -- for Inserting into JAI_OM_WSH_LINES_ALL Table.
4570: OPEN Get_Tot_Tax_Amount_Cur;
4571: FETCH Get_Tot_Tax_Amount_Cur INTO ln_tot_tax_amount;
4572: CLOSE Get_Tot_Tax_Amount_Cur;
4573:

Line 4598: -- Check for fulfilled non-shippable lines existence on JAI_OM_WSH_LINES_ALL Table

4594: ln_order_type_id
4595: , ln_order_number;
4596: CLOSE cur_get_order_header_info;
4597:
4598: -- Check for fulfilled non-shippable lines existence on JAI_OM_WSH_LINES_ALL Table
4599: OPEN Get_Fulfill_Line_Count_Cur;
4600: FETCH Get_Fulfill_Line_Count_Cur INTO ln_fulfill_line_count;
4601: CLOSE Get_Fulfill_Line_Count_Cur;
4602: IF ln_fulfill_line_count = 0

Line 4604: INSERT INTO JAI_OM_WSH_LINES_ALL(Delivery_Detail_Id

4600: FETCH Get_Fulfill_Line_Count_Cur INTO ln_fulfill_line_count;
4601: CLOSE Get_Fulfill_Line_Count_Cur;
4602: IF ln_fulfill_line_count = 0
4603: THEN
4604: INSERT INTO JAI_OM_WSH_LINES_ALL(Delivery_Detail_Id
4605: , Order_Header_Id
4606: , Order_Line_Id
4607: , split_from_delivery_detail_id
4608: , Selling_Price

Line 4857: UPDATE JAI_OM_WSH_LINES_ALL

4853: END IF;*/ --nvl(lv_enable_gst_flag,'N') = 'N'
4854: ----------------------------------------------------------
4855: --Added by Bo Li for bug#10043656 End
4856: ELSE
4857: UPDATE JAI_OM_WSH_LINES_ALL
4858: SET quantity = ln_fulfilled_quantity,
4859: tax_amount = ln_tot_tax_amount,
4860: order_line_id = ln_order_line_id,
4861: excise_amount = NULL,

Line 5585: FROM JAI_OM_WSH_LINES_ALL

5581: v_exist_ship NUMBER; --2002/03/08 Gadde Srinivas
5582:
5583: CURSOR get_count IS
5584: SELECT COUNT(*)
5585: FROM JAI_OM_WSH_LINES_ALL
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