APPS.JAI_AR_IMPORT_POPU_PKG dependencies on WSH_NEW_DELIVERIES

Line 32: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

28: v_header_id number;
29: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
30: CURSOR SO_PICKING_RECORD_CHECK IS
31: SELECT 1
32: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
33: WHERE A.delivery_id = B.DELIVERY_ID AND
34: B.NAME = v_interface_line_attribute3
35: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
36:

Line 99: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

95: t_rec_old jai_ar_trxs%rowtype;
96:
97: CURSOR SO_PICKING_HDR_INFO IS
98: SELECT A.organization_id, A.location_id
99: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
100: WHERE A.delivery_id = B.DELIVERY_ID AND
101: B.NAME = v_interface_line_attribute3 AND
102: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
103:

Line 213: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C

209: WHERE customer_trx_id = pr_new.customer_trx_id;
210:
211: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
212: SELECT DISTINCT 1
213: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
214: WHERE A.delivery_detail_id = b.delivery_detail_id
215: AND b.delivery_id = C.DELIVERY_ID AND
216: c.NAME = v_interface_line_attribute3
217: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

230: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
231: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
232: b.vat_invoice_no,b.vat_invoice_date
233: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
235: WHERE A.delivery_detail_id = b.delivery_detail_id
236: AND A.tax_id=c.tax_id
237: and c.tax_type <> 'Modvat Recovery'
238: AND b.delivery_id = D.delivery_id

Line 246: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C

242: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
243: SELECT SUM(A.base_tax_amount) base_tax_amount,
244: SUM(A.tax_amount) tax_amount,
245: SUM(A.func_tax_amount) func_tax_amount
246: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
247: WHERE A.delivery_detail_id = b.delivery_detail_id
248: AND b.delivery_id = c.delivery_id
249: AND c.NAME = v_interface_line_attribute3
250: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

Line 272: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

268: preprinted_excise_inv_no, excise_invoice_date,
269: excise_exempt_type, excise_exempt_refno, excise_exempt_date
270: , ar3_form_no, ar3_form_date,
271: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value, vat_invoice_no, vat_invoice_date
272: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
273: WHERE A.delivery_id = b.delivery_id AND
274: B.NAME = v_interface_line_attribute3 AND
275: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
276:

Line 1243: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1239: WHERE order_line_id = v_ato_line_id;
1240:
1241: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1242: SELECT a.organization_id, a.location_id
1243: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1244: WHERE a.delivery_id = b.delivery_id and
1245: B.NAME = v_interface_line_attribute3 AND
1246: A.order_line_id = TO_NUMBER(v_ato_line_id);
1247:

Line 4413: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

4409: CURSOR get_header_info_cur IS
4410: SELECT A.organization_id,
4411: A.location_id,
4412: A.order_type_id
4413: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
4414: WHERE A.delivery_id = B.DELIVERY_ID AND
4415: B.NAME = v_interface_line_attribute3 AND
4416: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
4417: