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

Line 2122: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2118:
2119: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2120:
2121: -----insert data into temp table
2122: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2123: ( party_id
2124: , party_name
2125: , party_number
2126: , party_level

Line 2241: UPDATE oe_credit_exposure_temp

2237: OE_DEBUG_PUB.ADD('Party has credit profiles ');
2238: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2239:
2240: ----update temp table with unchecked exposure
2241: UPDATE oe_credit_exposure_temp
2242: SET unchecked_exposure=l_party_unchk_exposure
2243: WHERE party_id=party_csr_rec.party_id
2244: AND customer_id IS NULL;
2245:

Line 2254: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2250: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
2251: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2252:
2253: -----insert data into temp table
2254: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2255: ( party_id
2256: , party_name
2257: , party_number
2258: , party_level

Line 2461: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2457:
2458: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2459:
2460: -----insert data into temp table
2461: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2462: ( party_id
2463: , party_name
2464: , party_number
2465: , party_level

Line 2580: UPDATE oe_credit_exposure_temp

2576: OE_DEBUG_PUB.ADD('Party has credit profiles ');
2577: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2578:
2579: ----update temp table with unchecked exposure
2580: UPDATE oe_credit_exposure_temp
2581: SET unchecked_exposure=l_party_unchk_exposure
2582: WHERE party_id=party_hier_csr_rec.party_id
2583: AND customer_id IS NULL;
2584:

Line 2593: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2589: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
2590: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2591:
2592: -----insert data into temp table
2593: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2594: ( party_id
2595: , party_name
2596: , party_number
2597: , party_level

Line 2754: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2750:
2751: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2752:
2753: -----insert data into temp table
2754: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2755: ( party_id
2756: , party_name
2757: , party_number
2758: , party_level

Line 2876: UPDATE oe_credit_exposure_temp

2872: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
2873: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2874:
2875: ----update temp table with unchecked exposure
2876: UPDATE oe_credit_exposure_temp
2877: SET unchecked_exposure=l_cust_unchk_exposure
2878: WHERE customer_id=party_cust_csr_rec.customer_id
2879: AND party_id=party_hier_csr_rec.party_id
2880: AND bill_to_site_id IS NULL

Line 2891: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2887: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
2888: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2889:
2890: -----insert data into temp table
2891: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2892: ( party_id
2893: , party_name
2894: , party_number
2895: , party_level

Line 3060: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3056:
3057: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3058:
3059: -----insert data into temp table
3060: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3061: ( party_id
3062: , party_name
3063: , party_number
3064: , party_level

Line 3181: UPDATE oe_credit_exposure_temp

3177: OE_DEBUG_PUB.ADD('Party has credit profiles ');
3178: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
3179:
3180: ----update temp table with unchecked exposure
3181: UPDATE oe_credit_exposure_temp
3182: SET unchecked_exposure=l_party_unchk_exposure
3183: WHERE party_id=party_hier_csr1_rec.party_id
3184: AND customer_id IS NULL;
3185:

Line 3194: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3190: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
3191: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
3192:
3193: -----insert data into temp table
3194: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3195: ( party_id
3196: , party_name
3197: , party_number
3198: , party_level

Line 3357: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3353:
3354: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3355:
3356: -----insert data into temp table
3357: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3358: ( party_id
3359: , party_name
3360: , party_number
3361: , party_level

Line 3477: UPDATE oe_credit_exposure_temp

3473: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
3474: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
3475:
3476: ----update temp table with unchecked exposure
3477: UPDATE oe_credit_exposure_temp
3478: SET unchecked_exposure=l_cust_unchk_exposure
3479: WHERE customer_id=party_cust_csr_rec.customer_id
3480: AND party_id=party_hier_csr1_rec.party_id
3481: AND bill_to_site_id IS NULL

Line 3492: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3488: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
3489: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
3490:
3491: -----insert data into temp table
3492: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3493: ( party_id
3494: , party_name
3495: , party_number
3496: , party_level

Line 3858: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3854:
3855: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3856:
3857: -----insert data into temp table
3858: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3859: ( party_id
3860: , party_name
3861: , party_number
3862: , party_level

Line 3978: UPDATE oe_credit_exposure_temp

3974: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
3975: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
3976:
3977: ----update temp table with unchecked exposure
3978: UPDATE oe_credit_exposure_temp
3979: SET unchecked_exposure=l_cust_unchk_exposure
3980: WHERE customer_id=cust_csr_rec.customer_id
3981: AND bill_to_site_id IS NULL
3982: AND party_id IS NULL;

Line 3992: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3988: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
3989: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
3990:
3991: -----insert data into temp table
3992: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3993: ( party_id
3994: , party_name
3995: , party_number
3996: , party_level

Line 4144: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

4140: OE_DEBUG_PUB.ADD('GL_currency_api.Convert_closest_amount_sql ');
4141: OE_DEBUG_PUB.ADD('l_base_cur_available = '|| TO_CHAR(l_base_cur_available));
4142:
4143: -----insert data into temp table
4144: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
4145: ( party_id
4146: , party_name
4147: , party_number
4148: , party_level

Line 4258: UPDATE oe_credit_exposure_temp

4254: OE_DEBUG_PUB.ADD('Customer site has credit profiles ');
4255: OE_DEBUG_PUB.ADD('Update temp table with unchecked_exposure ');
4256:
4257: ----update temp table with unchecked exposure for bill-to site
4258: UPDATE oe_credit_exposure_temp
4259: SET unchecked_exposure=l_site_unchk_exposure
4260: WHERE customer_id=cust_csr_rec.customer_id
4261: AND bill_to_site_id=site_csr_rec.site_id;
4262:

Line 4270: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

4266:
4267: OE_DEBUG_PUB.ADD('Customer site does not have credit profiles ');
4268: OE_DEBUG_PUB.ADD('Insert into temp table unchecked_exposure ');
4269:
4270: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
4271: ( party_id
4272: , party_name
4273: , party_number
4274: , party_level

Line 4335: FROM OE_CREDIT_EXPOSURE_TEMP;

4331: ---- from the temp table, so that report will print no data found
4332: IF l_return_status1='C'
4333: THEN
4334: DELETE
4335: FROM OE_CREDIT_EXPOSURE_TEMP;
4336: END IF;
4337:
4338: COMMIT;
4339: OE_DEBUG_PUB.ADD('Out of OEXRCRCB:Credit_exposure_report_utils with the status='||x_return_status);