APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on WSH_NEW_DELIVERIES

Line 772: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

768: WHERE customer_trx_id = v_header_id;
769:
770: CURSOR SO_PICKING_HDR_INFO IS
771: SELECT A.organization_id, A.location_id
772: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
773: WHERE A.delivery_id = B.DELIVERY_ID AND
774: B.NAME = v_interface_line_attribute3 AND
775: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
776:

Line 866: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

862: , gst_invoice_date
863: ----------------------------------
864: --Added by Bo Li for bug#10091373 End
865: */
866: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
867: WHERE A.delivery_id = b.delivery_id AND
868: B.NAME = v_interface_line_attribute3 AND
869: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
870:

Line 935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

931: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
932: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
933: b.vat_invoice_no,b.vat_invoice_date
934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
936: WHERE A.delivery_detail_id = b.delivery_detail_id
937: AND A.tax_id=c.tax_id
938: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/
939: AND b.delivery_id = D.delivery_id

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

944: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
945: SELECT SUM(A.base_tax_amount) base_tax_amount,
946: SUM(A.tax_amount) tax_amount,
947: SUM(A.func_tax_amount) func_tax_amount
948: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
949: WHERE A.delivery_detail_id = b.delivery_detail_id
950: AND b.delivery_id = c.delivery_id
951: -- AND c.NAME = v_interface_line_attribute3 -- commented for bug 14459402
952: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

Line 1036: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1032: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
1033:
1034: CURSOR SO_PICKING_RECORD_CHECK IS
1035: SELECT 1
1036: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1037: WHERE A.delivery_id = B.DELIVERY_ID AND
1038: B.NAME = v_interface_line_attribute3
1039: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1040:

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

1057: AND A.customer_trx_id = b.customer_trx_id;
1058:
1059: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
1060: SELECT DISTINCT 1
1061: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
1062: WHERE A.delivery_detail_id = b.delivery_detail_id
1063: AND b.delivery_id = C.DELIVERY_ID AND
1064: c.NAME = v_interface_line_attribute3
1065: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 1189: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B

1185: CURSOR get_header_info_cur IS
1186: SELECT A.organization_id,
1187: A.location_id,
1188: A.order_type_id
1189: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
1190: WHERE A.delivery_id = B.DELIVERY_ID AND
1191: B.NAME = v_interface_line_attribute3
1192: AND A.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1193:

Line 1467: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b

1463: WHERE order_line_id = v_ato_line_id;
1464:
1465: CURSOR so_ato_picking_hdr_info(v_ato_line_id Varchar2) IS
1466: SELECT a.organization_id, a.location_id
1467: FROM JAI_OM_WSH_LINES_ALL a,wsh_new_deliveries b
1468: WHERE a.delivery_id = b.delivery_id and
1469: B.NAME = v_interface_line_attribute3 AND
1470: A.order_line_id = TO_NUMBER(v_ato_line_id);
1471: