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 JAI_OM_WSH_LINES_ALL

Line 192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,

188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:
192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
193: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
194: )
195: IS
196: SELECT 1

Line 193: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE

189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:
192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
193: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
194: )
195: IS
196: SELECT 1
197: FROM jai_rgm_parties rgmpt,

Line 1102: -- get the details from JAI_OM_WSH_LINES_ALL table

1098: p_order_number NUMBER,
1099: px_return_code out nocopy varchar2,
1100: px_return_message out nocopy varchar2) IS
1101:
1102: -- get the details from JAI_OM_WSH_LINES_ALL table
1103: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1104: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1105: SELECT pl.inventory_item_id inventory_item_id,
1106: pl.unit_code unit_code,

Line 1112: FROM JAI_OM_WSH_LINES_ALL pl

1108: pl.tax_category_id tax_category_id,
1109: pl.selling_price selling_price,
1110: sum(pl.tax_amount) tax_amount,
1111: min(pl.delivery_detail_id) delivery_detail_id
1112: FROM JAI_OM_WSH_LINES_ALL pl
1113: WHERE pl.order_header_id = p_source_document_id
1114: AND pl.order_line_id = p_source_document_line_id
1115: GROUP BY pl.inventory_item_id,
1116: pl.unit_code,

Line 1135: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,

1131:
1132: l_exists VARCHAR2(1);
1133: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
1134:
1135: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1136: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1137: SELECT ptl.tax_line_no tax_line_no,
1138: ptl.tax_id tax_id,
1139: ptl.tax_rate tax_rate,

Line 1136: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS

1132: l_exists VARCHAR2(1);
1133: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
1134:
1135: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1136: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1137: SELECT ptl.tax_line_no tax_line_no,
1138: ptl.tax_id tax_id,
1139: ptl.tax_rate tax_rate,
1140: ptl.qty_rate qty_rate,

Line 1158: FROM JAI_OM_WSH_LINES_ALL pl,

1154: SUM(ptl.tax_amount) tax_amount,
1155: SUM(ptl.base_tax_amount) base_tax_amount,
1156: SUM(ptl.func_tax_amount) func_tax_amount,
1157: MIN(ptl.delivery_detail_id) delivery_detail_id
1158: FROM JAI_OM_WSH_LINES_ALL pl,
1159: JAI_OM_WSH_LINE_TAXES ptl,
1160: JAI_CMN_TAXES_ALL jtc
1161: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1162: AND pl.order_header_id = p_source_document_id

Line 1183: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,

1179: precedence_10,
1180: jtc.tax_type,
1181: nvl(jtc.rounding_factor, 0);
1182:
1183: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1184: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1185: --commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1186: /*SELECT sum(quantity)
1187: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl

Line 1184: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS

1180: jtc.tax_type,
1181: nvl(jtc.rounding_factor, 0);
1182:
1183: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1184: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1185: --commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1186: /*SELECT sum(quantity)
1187: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl
1188: WHERE ptl.delivery_detail_id = pl.delivery_detail_id

Line 1187: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl

1183: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1184: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1185: --commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1186: /*SELECT sum(quantity)
1187: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl
1188: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1189: AND pl.order_header_id = p_source_document_id
1190: AND pl.order_line_id = p_source_document_line_id;*/
1191: --commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.

Line 1194: FROM JAI_OM_WSH_LINES_ALL

1190: AND pl.order_line_id = p_source_document_line_id;*/
1191: --commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1192: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1193: SELECT quantity
1194: FROM JAI_OM_WSH_LINES_ALL
1195: WHERE order_header_id = p_source_document_id
1196: AND order_line_id = p_source_document_line_id;
1197: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1198:

Line 1245: FROM JAI_OM_WSH_LINES_ALL

1241: WHERE header_id = pr_order_line.header_id;
1242:
1243: CURSOR c_fulfilled_date IS
1244: SELECT CREATION_DATE
1245: FROM JAI_OM_WSH_LINES_ALL
1246: WHERE ORDER_LINE_ID = pr_order_line.reference_line_id
1247: AND SHIPPABLE_FLAG = 'N';
1248:
1249: CURSOR c_get_ship_qty(p_source_document_id NUMBER,

Line 1255: FROM JAI_OM_WSH_LINES_ALL

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
1257: and order_line_id = p_source_document_line_id)
1258: AND wdd.inventory_item_id = pr_order_line.inventory_item_id;
1259:

Line 1260: CURSOR cur_get_picking_tax_lines_new(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,

1256: WHERE order_header_id = p_source_document_id
1257: and order_line_id = p_source_document_line_id)
1258: AND wdd.inventory_item_id = pr_order_line.inventory_item_id;
1259:
1260: CURSOR cur_get_picking_tax_lines_new(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1261: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1262:
1263: SELECT ptl.tax_line_no tax_line_no,
1264: ptl.tax_id tax_id,

Line 1261: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS

1257: and order_line_id = p_source_document_line_id)
1258: AND wdd.inventory_item_id = pr_order_line.inventory_item_id;
1259:
1260: CURSOR cur_get_picking_tax_lines_new(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1261: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1262:
1263: SELECT ptl.tax_line_no tax_line_no,
1264: ptl.tax_id tax_id,
1265: ptl.tax_rate tax_rate,

Line 1282: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl

1278: SUM(ptl.tax_amount) tax_amount,
1279: SUM(ptl.base_tax_amount) base_tax_amount,
1280: SUM(ptl.func_tax_amount) func_tax_amount,
1281: MIN(ptl.delivery_detail_id) delivery_detail_id
1282: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl
1283: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1284: AND pl.order_header_id = p_source_document_id
1285: AND pl.order_line_id = p_source_document_line_id
1286: GROUP by tax_line_no,

Line 1315: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

1311:
1312: lv_check_vat_type_exists VARCHAR2(1);
1313: v_date_ordered DATE;
1314: v_date_confirmed DATE;
1315: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1316: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1317: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1318: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1319: v_excise_flag VARCHAR2(1);

Line 1329: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

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

Line 1332: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
1333: v_orig_ord_qty Number;
1334: v_rma_quantity_uom VARCHAR2(3);
1335: v_service_type_code varchar2(30);
1336:

Line 1851: -- get the details from JAI_OM_WSH_LINES_ALL table

1847:
1848: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1850:
1851: -- get the details from JAI_OM_WSH_LINES_ALL table
1852: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1853: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1854: SELECT pl.inventory_item_id inventory_item_id,
1855: pl.unit_code unit_code,

Line 1861: FROM JAI_OM_WSH_LINES_ALL pl

1857: pl.tax_category_id tax_category_id,
1858: pl.selling_price selling_price,
1859: sum(pl.tax_amount) tax_amount,
1860: min(pl.delivery_detail_id) delivery_detail_id
1861: FROM JAI_OM_WSH_LINES_ALL pl
1862: WHERE pl.order_header_id = p_source_document_id
1863: AND pl.order_line_id = p_source_document_line_id
1864: GROUP BY pl.inventory_item_id,
1865: pl.unit_code,

Line 1885: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,

1881: l_exists VARCHAR2(1);
1882:
1883: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
1884:
1885: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1886: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1887: SELECT ptl.tax_line_no tax_line_no,
1888: ptl.tax_id tax_id,
1889: ptl.tax_rate tax_rate,

Line 1886: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS

1882:
1883: rec_cur_get_picking_lines cur_get_picking_lines%ROWTYPE;
1884:
1885: CURSOR cur_get_picking_tax_lines(p_source_document_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE,
1886: p_source_document_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE) IS
1887: SELECT ptl.tax_line_no tax_line_no,
1888: ptl.tax_id tax_id,
1889: ptl.tax_rate tax_rate,
1890: ptl.qty_rate qty_rate,

Line 1908: FROM JAI_OM_WSH_LINES_ALL pl,

1904: SUM(ptl.tax_amount) tax_amount,
1905: SUM(ptl.base_tax_amount) base_tax_amount,
1906: SUM(ptl.func_tax_amount) func_tax_amount,
1907: MIN(ptl.delivery_detail_id) delivery_detail_id
1908: FROM JAI_OM_WSH_LINES_ALL pl,
1909: JAI_OM_WSH_LINE_TAXES ptl,
1910: JAI_CMN_TAXES_ALL jtc
1911: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1912: AND pl.order_header_id = p_source_document_id

Line 1939: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,

1935: SELECT 'X'
1936: FROM JAI_OM_OE_RMA_TAXES
1937: WHERE rma_line_id = p_line_id
1938: AND tax_id = p_tax_id;
1939: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1940: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1941: -- cmmented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1942: /*SELECT sum(quantity)
1943: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl

Line 1940: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS

1936: FROM JAI_OM_OE_RMA_TAXES
1937: WHERE rma_line_id = p_line_id
1938: AND tax_id = p_tax_id;
1939: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1940: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1941: -- cmmented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1942: /*SELECT sum(quantity)
1943: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl
1944: WHERE ptl.delivery_detail_id = pl.delivery_detail_id

Line 1943: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl

1939: CURSOR c_get_quantity(p_source_document_id JAI_OM_WSH_LINES_ALL.order_header_id%type,
1940: p_source_document_line_id JAI_OM_WSH_LINES_ALL.order_line_id%type) IS
1941: -- cmmented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1942: /*SELECT sum(quantity)
1943: FROM JAI_OM_WSH_LINES_ALL pl, JAI_OM_WSH_LINE_TAXES ptl
1944: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1945: AND pl.order_header_id = p_source_document_id
1946: AND pl.order_line_id = p_source_document_line_id;*/
1947: -- commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.

Line 1950: FROM JAI_OM_WSH_LINES_ALL

1946: AND pl.order_line_id = p_source_document_line_id;*/
1947: -- commented out by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1948: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 begin
1949: SELECT quantity
1950: FROM JAI_OM_WSH_LINES_ALL
1951: WHERE order_header_id = p_source_document_id
1952: AND order_line_id = p_source_document_line_id;
1953: -- added by zhiwei.xin for bug#14669425 on 16-Oct-2012 end.
1954:

Line 2001: FROM JAI_OM_WSH_LINES_ALL

1997: WHERE header_id = pr_order_line.header_id;
1998:
1999: CURSOR c_fulfilled_date IS
2000: SELECT CREATION_DATE
2001: FROM JAI_OM_WSH_LINES_ALL
2002: WHERE ORDER_LINE_ID = pr_order_line.reference_line_id
2003: AND SHIPPABLE_FLAG = 'N';
2004:
2005: CURSOR c_get_ship_qty(p_source_document_id NUMBER,

Line 2011: FROM JAI_OM_WSH_LINES_ALL

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
2013: and order_line_id = p_source_document_line_id)
2014: AND wdd.inventory_item_id = pr_order_line.inventory_item_id;
2015:

Line 2019: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

2015:
2016: lv_check_vat_type_exists VARCHAR2(1);
2017: v_date_ordered DATE;
2018: v_date_confirmed DATE;
2019: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2020: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2021: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2022: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2023: v_excise_flag VARCHAR2(1);

Line 2033: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

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

Line 2036: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
2037: v_orig_ord_qty Number;
2038: v_rma_quantity_uom VARCHAR2(3);
2039: v_service_type_code varchar2(30);
2040:

Line 4488: FROM JAI_OM_WSH_LINES_ALL

4484: v_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_TAX';
4485:
4486: CURSOR get_count IS
4487: SELECT COUNT(*)
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