APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on WSH_NEW_DELIVERIES

Line 733: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

729: WHERE customer_trx_id = v_header_id;
730:
731: CURSOR SO_PICKING_HDR_INFO IS
732: SELECT A.organization_id, A.location_id
733: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
734: WHERE A.delivery_id = B.DELIVERY_ID AND
735: B.NAME = v_interface_line_attribute3 AND
736: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
737:

Line 800: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

796: preprinted_excise_inv_no, excise_invoice_date,
797: excise_exempt_type, excise_exempt_refno, excise_exempt_date
798: , ar3_form_no, ar3_form_date, -- Vijay Shankar for Bug # 3181892
799: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value, vat_invoice_no, vat_invoice_date -- added, Harshita for bug#4245062
800: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
801: WHERE A.delivery_id = b.delivery_id AND
802: B.NAME = v_interface_line_attribute3 AND
803: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
804:

Line 867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

863: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
864: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
865: b.vat_invoice_no,b.vat_invoice_date
866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
868: WHERE A.delivery_detail_id = b.delivery_detail_id
869: AND A.tax_id=c.tax_id
870: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/
871: AND b.delivery_id = D.delivery_id

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

876: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
877: SELECT SUM(A.base_tax_amount) base_tax_amount,
878: SUM(A.tax_amount) tax_amount,
879: SUM(A.func_tax_amount) func_tax_amount
880: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
881: WHERE A.delivery_detail_id = b.delivery_detail_id
882: AND b.delivery_id = c.delivery_id
883: AND c.NAME = v_interface_line_attribute3
884: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

Line 968: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

964: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
965:
966: CURSOR SO_PICKING_RECORD_CHECK IS
967: SELECT 1
968: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
969: WHERE A.delivery_id = B.DELIVERY_ID AND
970: B.NAME = v_interface_line_attribute3
971: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
972:

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

989: AND A.customer_trx_id = b.customer_trx_id;
990:
991: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
992: SELECT DISTINCT 1
993: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
994: WHERE A.delivery_detail_id = b.delivery_detail_id
995: AND b.delivery_id = C.DELIVERY_ID AND
996: c.NAME = v_interface_line_attribute3
997: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 1118: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1114: CURSOR get_header_info_cur IS
1115: SELECT A.organization_id,
1116: A.location_id,
1117: A.order_type_id
1118: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1119: WHERE A.delivery_id = B.DELIVERY_ID AND
1120: B.NAME = v_interface_line_attribute3
1121: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1122:

Line 1382: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1378: WHERE order_line_id = v_ato_line_id;
1379:
1380: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1381: SELECT a.organization_id, a.location_id
1382: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1383: WHERE a.delivery_id = b.delivery_id and
1384: B.NAME = v_interface_line_attribute3 AND
1385: A.order_line_id = TO_NUMBER(v_ato_line_id);
1386: