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_LINE_TAXES

Line 1159: JAI_OM_WSH_LINE_TAXES ptl,

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
1163: AND pl.order_line_id = p_source_document_line_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 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 1658: FROM JAI_OM_WSH_LINE_TAXES sptl,

1654: precedence_7,
1655: precedence_8,
1656: precedence_9,
1657: precedence_10
1658: FROM JAI_OM_WSH_LINE_TAXES sptl,
1659: JAI_CMN_TAXES_ALL jtc
1660: WHERE order_line_id =
1661: pr_order_line.reference_line_id
1662: AND jtc.tax_id = sptl.tax_id) LOOP

Line 1909: JAI_OM_WSH_LINE_TAXES ptl,

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
1913: AND pl.order_line_id = p_source_document_line_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 2492: FROM JAI_OM_WSH_LINE_TAXES sptl,

2488: precedence_7,
2489: precedence_8,
2490: precedence_9,
2491: precedence_10
2492: FROM JAI_OM_WSH_LINE_TAXES sptl,
2493: JAI_CMN_TAXES_ALL jtc
2494: WHERE order_line_id =
2495: pr_order_line.reference_line_id
2496: AND jtc.tax_id = sptl.tax_id) LOOP