APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 1178: from JAI_OM_WSH_LINES_ALL

1174: select order_line_id ,
1175: order_header_id ,
1176: organization_id ,
1177: location_id
1178: from JAI_OM_WSH_LINES_ALL
1179: where delivery_detail_id = p_delivery_detail_id;
1180:
1181: cursor c_get_order_info(
1182: p_order_header_id number

Line 1210: JAI_OM_WSH_LINES_ALL jspl ,

1206: oeh.ship_to_org_id customer_site_id,
1207: jspl.excise_invoice_no
1208: FROM wsh_new_deliveries wnd ,
1209: wsh_delivery_details wdd ,
1210: JAI_OM_WSH_LINES_ALL jspl ,
1211: oe_order_headers_all oeh
1212: WHERE jspl.delivery_id = wnd.delivery_id
1213: AND wdd.delivery_Detail_id = jspl.delivery_detail_id
1214: AND wdd.source_header_id = oeh.header_id

Line 1268: from JAI_OM_WSH_LINES_ALL

1264: JAI_CMN_TAXES_ALL jtc
1265: where delivery_detail_id in
1266: (
1267: select delivery_detail_id
1268: from JAI_OM_WSH_LINES_ALL
1269: where delivery_id = p_delivery_id
1270: )
1271: and jtc.tax_id = jsptl.tax_id
1272: 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 1293: v_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;

1289: v_orgn_id number;
1290: v_locn_id number;
1291: v_order_flag char(1); -- := 'O'; --Ramananda for File.Sql.35
1292:
1293: v_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1294:
1295: /*
1296: the purpose of the following function is to calculate the base tax amounts
1297: This needs to be specifically used in cases such as 0%tax added manually.

Line 1324: from JAI_OM_WSH_LINES_ALL

1320:
1321: cursor c_get_line_amount
1322: is
1323: select selling_price * quantity line_amount
1324: from JAI_OM_WSH_LINES_ALL
1325: where delivery_detail_id = p_delivery_Detail_id;
1326:
1327: v_prec_rec c_get_precedences%rowtype;
1328: