eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_HDRS_ALL_S1

Line 18: Sequence JAI_AR_SUP_HDRS_ALL_S1 is used instead of JAI_AR_SUP_HDRS_ALL_S2 and JAI_AR_SUP_HDRS_ALL_S3

14: 13-Jun-2005 File Version: 116.4
15: Ramananda for bug#4428980. Removal of SQL LITERALs is done
16:
17: 18-JUL-2005 Ramananda for bug# 4499078, File Version # 120.2
18: Sequence JAI_AR_SUP_HDRS_ALL_S1 is used instead of JAI_AR_SUP_HDRS_ALL_S2 and JAI_AR_SUP_HDRS_ALL_S3
19:
20: 26-JUL-2005 Ramananda for bug#4499078, File Version # 120.3
21: Added column Interface_Line_Attribute2 column in Cursor GET_SUPP_INV_LINES
22:

Line 2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2211: FOR SUPP_INV IN GET_SUPP_INV
2212: LOOP
2213: if supp_inv.supp_inv_type = 'CR' then
2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then

Line 2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;
2222: open get_address(supp_inv.bill_to_site_use_id);

Line 2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;
2222: open get_address(supp_inv.bill_to_site_use_id);
2223: fetch get_address into v_address;
2224: close get_address;

Line 2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2391: for cnsldt_header in get_cnsldt_header
2392: loop
2393: IF cnsldt_header.supp_inv_type = 'CR' then
2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then

Line 2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;
2402:

Line 2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;
2402:
2403: for inv_cnsldt in get_inv_cnsldt(cnsldt_header.set_of_books_id,cnsldt_header.customer_id,
2404: cnsldt_header.customer_site,cnsldt_header.supp_inv_type)