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.ONT_OEXCEXP_XMLP_PKG dependencies on OE_CREDIT_EXPOSURE_TEMP

Line 137: OE_CREDIT_EXPOSURE_TEMP

133: SELECT
134: SUM(BASE_CUR_OVERALL_LIMIT)
135: INTO CP_CUST_LIMIT_GRAND_TOTAL
136: FROM
137: OE_CREDIT_EXPOSURE_TEMP
138: WHERE CUSTOMER_ID = D_CUSTOMER_ID
139: AND BILL_TO_SITE_ID IS NOT NULL;
140: RETURN (0);
141: END CF_GET_LIMIT_G_TOTALFORMULA;

Line 151: OE_CREDIT_EXPOSURE_TEMP

147: SELECT
148: SUM(BASE_CUR_EXPOSURE)
149: INTO L_EXPOSURE
150: FROM
151: OE_CREDIT_EXPOSURE_TEMP
152: WHERE CUSTOMER_ID = D_CUSTOMER_ID
153: AND BILL_TO_SITE_ID IS NOT NULL;
154: SELECT
155: SUM(UNCHECKED_EXPOSURE)

Line 158: OE_CREDIT_EXPOSURE_TEMP

154: SELECT
155: SUM(UNCHECKED_EXPOSURE)
156: INTO L_UNCHECKED_EXPOSURE
157: FROM
158: OE_CREDIT_EXPOSURE_TEMP
159: WHERE CUSTOMER_ID = D_CUSTOMER_ID
160: AND BILL_TO_SITE_ID IS NOT NULL;
161: CP_CUST_EXPOSURE_GRAND_TOTAL := L_EXPOSURE + L_UNCHECKED_EXPOSURE;
162: RETURN (0);

Line 171: OE_CREDIT_EXPOSURE_TEMP

167: SELECT
168: SUM(BASE_CUR_AVAILABLE)
169: INTO CP_CUST_AVAILABLE_GRAND_TOTAL
170: FROM
171: OE_CREDIT_EXPOSURE_TEMP
172: WHERE CUSTOMER_ID = D_CUSTOMER_ID
173: AND BILL_TO_SITE_ID IS NOT NULL;
174: RETURN (0);
175: END CF_GET_AVAIL_G_TOTALFO;

Line 645: FROM OE_CREDIT_EXPOSURE_TEMP

641:
642: BEGIN
643: SELECT COUNT(1)
644: INTO L_COUNT
645: FROM OE_CREDIT_EXPOSURE_TEMP
646: WHERE PARTY_ID IS NOT NULL
647: AND CUSTOMER_ID IS NOT NULL
648: AND REPORT_BY_OPTION='PARTY_DETAILS';
649: