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_S

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 1063: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1059: FETCH CHECK_SUPP_ASSESS_INV INTO CHECK_ASSESS_INV ;
1060:
1061: IF CHECK_SUPP_ASSESS_INV%NOTFOUND THEN
1062: v_statement_id := '21';
1063: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1064: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1065: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1066: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1067: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

Line 1067: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1063: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1064: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1065: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1066: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1067: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1068: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1069: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1070: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1071: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

Line 1198: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1194: IF CHECK_SUPP_ASSESS_INV%NOTFOUND THEN
1195:
1196: v_statement_id := '37';
1197:
1198: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1199: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1200: LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1201: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1202: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

Line 1203: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1199: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1200: LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1201: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1202: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1203: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1204: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1205: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,
1206: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, I.SET_OF_BOOKS_ID,
1207: I.BILL_TO_SITE_USE_ID, I.ORG_ID, FETCH_INV.BATCH_ID, 'N', 'N'

Line 1638: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1634:
1635: v_statement_id := '78';
1636:
1637:
1638: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1639: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1640: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1641: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1642: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

Line 1642: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1638: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1639: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1640: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1641: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1642: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1643: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1644: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1645: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1646: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

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

2078: IF CHSN_FOR_CNSLDT = 'N' OR CHSN_FOR_CNSLDT IS NULL THEN
2079: FOR SUPP_INV IN GET_SUPP_INV
2080: LOOP
2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

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

2079: FOR SUPP_INV IN GET_SUPP_INV
2080: LOOP
2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then

Line 2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;

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

2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;
2090: open get_address(supp_inv.bill_to_site_use_id);

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

2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;
2090: open get_address(supp_inv.bill_to_site_use_id);
2091: fetch get_address into v_address;
2092: close get_address;

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

2252: Elsif CHSN_FOR_CNSLDT = 'Y' THEN
2253: for cnsldt_header in get_cnsldt_header
2254: loop
2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

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

2253: for cnsldt_header in get_cnsldt_header
2254: loop
2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then

Line 2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;

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

2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;
2264:

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

2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;
2264:
2265: for inv_cnsldt in get_inv_cnsldt(cnsldt_header.set_of_books_id,cnsldt_header.customer_id,
2266: cnsldt_header.customer_site,cnsldt_header.supp_inv_type)