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 DUAL

Line 793: FROM DUAL;

789: /*Added the below by Bgowrava for Bug#6139693
790: CURSOR c_get_sup_seq_val
791: IS
792: SELECT JAI_AR_SUP_LINES_S.NEXTVAL
793: FROM DUAL;
794:
795: v_cust_trx_line_no_s NUMBER;
796: v_cust_trx_line_no_s1 NUMBER;
797: END, Bug#6139693*/

Line 2168: from dual;

2164:
2165:
2166: cursor c_legal_entity_id (cp_org_id NUMBER) IS
2167: SELECT XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU( cp_org_id )
2168: from dual;
2169:
2170: /* Bug 4906958. Added by Lakshmi Gopalsami
2171: Get the value of legal entity from hr_operating_units
2172: if the above cursor is returning null.

Line 2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2210: IF CHSN_FOR_CNSLDT = 'N' OR CHSN_FOR_CNSLDT IS NULL THEN
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;

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 2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

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
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;

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 2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2390: Elsif CHSN_FOR_CNSLDT = 'Y' THEN
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;

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 2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

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
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;

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)