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 2133: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2129:
2130: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2131:
2132: -----insert data into temp table
2133: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2134: ( party_id
2135: , party_name
2136: , party_number
2137: , party_level

Line 2253: UPDATE oe_credit_exposure_temp

2249: OE_DEBUG_PUB.ADD('Party has credit profiles ');
2250: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2251:
2252: ----update temp table with unchecked exposure
2253: UPDATE oe_credit_exposure_temp
2254: SET unchecked_exposure=l_party_unchk_exposure
2255: WHERE party_id=party_csr_rec.party_id
2256: AND customer_id IS NULL;
2257:

Line 2266: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2262: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
2263: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2264:
2265: -----insert data into temp table
2266: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2267: ( party_id
2268: , party_name
2269: , party_number
2270: , party_level

Line 2473: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2469:
2470: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2471:
2472: -----insert data into temp table
2473: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2474: ( party_id
2475: , party_name
2476: , party_number
2477: , party_level

Line 2593: UPDATE oe_credit_exposure_temp

2589: OE_DEBUG_PUB.ADD('Party has credit profiles ');
2590: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2591:
2592: ----update temp table with unchecked exposure
2593: UPDATE oe_credit_exposure_temp
2594: SET unchecked_exposure=l_party_unchk_exposure
2595: WHERE party_id=party_hier_csr_rec.party_id
2596: AND customer_id IS NULL;
2597:

Line 2606: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2602: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
2603: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2604:
2605: -----insert data into temp table
2606: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2607: ( party_id
2608: , party_name
2609: , party_number
2610: , party_level

Line 2767: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2763:
2764: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
2765:
2766: -----insert data into temp table
2767: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2768: ( party_id
2769: , party_name
2770: , party_number
2771: , party_level

Line 2890: UPDATE oe_credit_exposure_temp

2886: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
2887: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
2888:
2889: ----update temp table with unchecked exposure
2890: UPDATE oe_credit_exposure_temp
2891: SET unchecked_exposure=l_cust_unchk_exposure
2892: WHERE customer_id=party_cust_csr_rec.customer_id
2893: AND party_id=party_hier_csr_rec.party_id
2894: AND bill_to_site_id IS NULL

Line 2905: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

2901: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
2902: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
2903:
2904: -----insert data into temp table
2905: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
2906: ( party_id
2907: , party_name
2908: , party_number
2909: , party_level

Line 3074: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3070:
3071: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3072:
3073: -----insert data into temp table
3074: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3075: ( party_id
3076: , party_name
3077: , party_number
3078: , party_level

Line 3196: UPDATE oe_credit_exposure_temp

3192: OE_DEBUG_PUB.ADD('Party has credit profiles ');
3193: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
3194:
3195: ----update temp table with unchecked exposure
3196: UPDATE oe_credit_exposure_temp
3197: SET unchecked_exposure=l_party_unchk_exposure
3198: WHERE party_id=party_hier_csr1_rec.party_id
3199: AND customer_id IS NULL;
3200:

Line 3209: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3205: OE_DEBUG_PUB.ADD('Party does not have any credit profiles ');
3206: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
3207:
3208: -----insert data into temp table
3209: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3210: ( party_id
3211: , party_name
3212: , party_number
3213: , party_level

Line 3372: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3368:
3369: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3370:
3371: -----insert data into temp table
3372: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3373: ( party_id
3374: , party_name
3375: , party_number
3376: , party_level

Line 3493: UPDATE oe_credit_exposure_temp

3489: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
3490: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
3491:
3492: ----update temp table with unchecked exposure
3493: UPDATE oe_credit_exposure_temp
3494: SET unchecked_exposure=l_cust_unchk_exposure
3495: WHERE customer_id=party_cust_csr_rec.customer_id
3496: AND party_id=party_hier_csr1_rec.party_id
3497: AND bill_to_site_id IS NULL

Line 3508: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3504: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
3505: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
3506:
3507: -----insert data into temp table
3508: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3509: ( party_id
3510: , party_name
3511: , party_number
3512: , party_level

Line 3883: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

3879:
3880: OE_DEBUG_PUB.ADD('IN Insert data into temp table ');
3881:
3882: -----insert data into temp table
3883: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
3884: ( party_id
3885: , party_name
3886: , party_number
3887: , party_level

Line 4004: UPDATE oe_credit_exposure_temp

4000: OE_DEBUG_PUB.ADD('Customer has credit profiles ');
4001: OE_DEBUG_PUB.ADD('Update temp table with unchecked exposure ');
4002:
4003: ----update temp table with unchecked exposure
4004: UPDATE oe_credit_exposure_temp
4005: SET unchecked_exposure=l_cust_unchk_exposure
4006: WHERE customer_id=cust_csr_rec.customer_id
4007: AND bill_to_site_id IS NULL
4008: AND party_id IS NULL;

Line 4018: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

4014: OE_DEBUG_PUB.ADD('Customer does not have any credit profiles ');
4015: OE_DEBUG_PUB.ADD('IN Insert data into temp table for unchecked exposure ');
4016:
4017: -----insert data into temp table
4018: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
4019: ( party_id
4020: , party_name
4021: , party_number
4022: , party_level

Line 4170: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

4166: OE_DEBUG_PUB.ADD('GL_currency_api.Convert_closest_amount_sql ');
4167: OE_DEBUG_PUB.ADD('l_base_cur_available = '|| TO_CHAR(l_base_cur_available));
4168:
4169: -----insert data into temp table
4170: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
4171: ( party_id
4172: , party_name
4173: , party_number
4174: , party_level

Line 4285: UPDATE oe_credit_exposure_temp

4281: OE_DEBUG_PUB.ADD('Customer site has credit profiles ');
4282: OE_DEBUG_PUB.ADD('Update temp table with unchecked_exposure ');
4283:
4284: ----update temp table with unchecked exposure for bill-to site
4285: UPDATE oe_credit_exposure_temp
4286: SET unchecked_exposure=l_site_unchk_exposure
4287: WHERE customer_id=cust_csr_rec.customer_id
4288: AND bill_to_site_id=site_csr_rec.site_id;
4289:

Line 4297: INSERT INTO OE_CREDIT_EXPOSURE_TEMP

4293:
4294: OE_DEBUG_PUB.ADD('Customer site does not have credit profiles ');
4295: OE_DEBUG_PUB.ADD('Insert into temp table unchecked_exposure ');
4296:
4297: INSERT INTO OE_CREDIT_EXPOSURE_TEMP
4298: ( party_id
4299: , party_name
4300: , party_number
4301: , party_level

Line 4362: FROM OE_CREDIT_EXPOSURE_TEMP;

4358: ---- from the temp table, so that report will print no data found
4359: IF l_return_status1='C'
4360: THEN
4361: DELETE
4362: FROM OE_CREDIT_EXPOSURE_TEMP;
4363: END IF;
4364:
4365: COMMIT;
4366: OE_DEBUG_PUB.ADD('Out of OEXRCRCB:Credit_exposure_report_utils with the status='||x_return_status);