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.JA_JAINSTPR_XMLP_PKG dependencies on JAI_AR_SUP_HDRS_ALL

Line 18: JAI_AR_SUP_HDRS_ALL C

14: SUM(DIFF_AMT) EXCISE
15: FROM
16: JAI_AR_SUP_TAXES A,
17: JAI_AR_SUP_LINES B,
18: JAI_AR_SUP_HDRS_ALL C
19: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
20: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
21: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
22: AND B.SUP_INV_TYPE = A.SUP_INV_TYPE

Line 53: JAI_AR_SUP_HDRS_ALL C

49: SUM(DIFF_AMT) SALES
50: FROM
51: JAI_AR_SUP_TAXES A,
52: JAI_AR_SUP_LINES B,
53: JAI_AR_SUP_HDRS_ALL C
54: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
55: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
56: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
57: AND B.SUP_INV_TYPE = A.SUP_INV_TYPE

Line 88: JAI_AR_SUP_HDRS_ALL C

84: SUM(DIFF_AMT) EXCISE
85: FROM
86: JAI_AR_SUP_TAXES A,
87: JAI_AR_SUP_LINES B,
88: JAI_AR_SUP_HDRS_ALL C
89: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
90: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
91: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
92: AND B.SUP_INV_TYPE = A.SUP_INV_TYPE

Line 126: JAI_AR_SUP_HDRS_ALL C

122: SUM(DIFF_AMT) OTHER
123: FROM
124: JAI_AR_SUP_TAXES A,
125: JAI_AR_SUP_LINES B,
126: JAI_AR_SUP_HDRS_ALL C
127: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
128: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
129: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
130: AND B.SUP_INV_TYPE = A.SUP_INV_TYPE

Line 230: JAI_AR_SUP_HDRS_ALL

226: FUNCTION AFTERREPORT RETURN BOOLEAN IS
227: BEGIN
228: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
229: UPDATE
230: JAI_AR_SUP_HDRS_ALL
231: SET
232: PROCESS_DATE = SYSDATE
233: WHERE PROCESS_DATE is null;
234: RETURN (TRUE);