DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_LINES_S

Line 720: SELECT JAI_AR_SUP_LINES_S.NEXTVAL

716:
717: /*Added the below by Bgowrava for Bug#6139693*/
718: CURSOR c_get_sup_seq_val
719: IS
720: SELECT JAI_AR_SUP_LINES_S.NEXTVAL
721: FROM DUAL;
722:
723: v_cust_trx_line_no_s NUMBER;
724: v_cust_trx_line_no_s1 NUMBER;

Line 817: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id

813:
814:
815: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
816: Added Cursor c_get_sup_seq_val which is used to generate sequence numbers from the sequence
817: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id
818: of the table JAI_AR_SUP_LINES.
819:
820: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
821: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of