APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 1318: from JAI_OM_WSH_LINES_ALL

1314: select order_line_id ,
1315: order_header_id ,
1316: organization_id ,
1317: location_id
1318: from JAI_OM_WSH_LINES_ALL
1319: where delivery_detail_id = p_delivery_detail_id;
1320:
1321: cursor c_get_order_info(
1322: p_order_header_id number

Line 1350: JAI_OM_WSH_LINES_ALL jspl ,

1346: oeh.ship_to_org_id customer_site_id,
1347: jspl.excise_invoice_no
1348: FROM wsh_new_deliveries wnd ,
1349: wsh_delivery_details wdd ,
1350: JAI_OM_WSH_LINES_ALL jspl ,
1351: oe_order_headers_all oeh
1352: WHERE jspl.delivery_id = wnd.delivery_id
1353: AND wdd.delivery_Detail_id = jspl.delivery_detail_id
1354: AND wdd.source_header_id = oeh.header_id

Line 1409: from JAI_OM_WSH_LINES_ALL

1405: JAI_CMN_TAXES_ALL jtc
1406: where delivery_detail_id in
1407: (
1408: select delivery_detail_id
1409: from JAI_OM_WSH_LINES_ALL
1410: where delivery_id = p_delivery_id
1411: )
1412: and jtc.tax_id = jsptl.tax_id
1413: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 1434: v_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;

1430: v_orgn_id number;
1431: v_locn_id number;
1432: v_order_flag char(1); -- := 'O'; --Ramananda for File.Sql.35
1433:
1434: v_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1435:
1436: /*
1437: the purpose of the following function is to calculate the base tax amounts
1438: This needs to be specifically used in cases such as 0%tax added manually.

Line 1465: from JAI_OM_WSH_LINES_ALL

1461:
1462: cursor c_get_line_amount
1463: is
1464: select selling_price * quantity line_amount
1465: from JAI_OM_WSH_LINES_ALL
1466: where delivery_detail_id = p_delivery_Detail_id;
1467:
1468: v_prec_rec c_get_precedences%rowtype;
1469: