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.OZF_SD_BATCH_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 1186: FROM ozf_sd_batch_lines_all

1182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Lines created.');
1183:
1184: SELECT sum(batch_curr_claim_amount)
1185: INTO l_batch_sum
1186: FROM ozf_sd_batch_lines_all
1187: WHERE batch_id = l_batch_id;
1188:
1189: -- Check for Batch Amount Threshold
1190:

Line 1782: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');

1778:
1779: FND_DSQL.init;
1780:
1781: FND_DSQL.add_text('SELECT ');
1782: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1783: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1784: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1785: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1786: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');

Line 2316: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');

2312: p_order_source);
2313: END IF;
2314:
2315: IF OZF_DEBUG_LOW_ON THEN
2316: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');
2317: END IF;
2318:
2319: IF OZF_DEBUG_LOW_ON THEN
2320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: start time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );

Line 2323: INSERT INTO OZF_SD_BATCH_LINES_ALL

2319: IF OZF_DEBUG_LOW_ON THEN
2320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: start time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
2321: END IF;
2322:
2323: INSERT INTO OZF_SD_BATCH_LINES_ALL
2324: (batch_line_id,
2325: object_version_number,
2326: batch_id,
2327: batch_line_number,

Line 2465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');

2461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: end time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
2462: END IF;
2463:
2464: IF OZF_DEBUG_LOW_ON THEN
2465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');
2466: END IF;
2467:
2468: l_batch_line_number := l_batch_line_number + 1;
2469: END IF;

Line 2651: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');

2647:
2648: FND_DSQL.init;
2649:
2650: FND_DSQL.add_text('SELECT ');
2651: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
2652: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
2653: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
2654: FND_DSQL.add_text('NULL, '); --SHIP_TO_ORG_ID
2655: FND_DSQL.add_text('NULL, '); -- SHIP_TO_CONTACT_ID

Line 3159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');

3155: p_order_source);
3156: END IF;
3157:
3158: IF OZF_DEBUG_LOW_ON THEN
3159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');
3160: END IF;
3161:
3162: IF OZF_DEBUG_LOW_ON THEN
3163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: start time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );

Line 3166: INSERT INTO OZF_SD_BATCH_LINES_ALL

3162: IF OZF_DEBUG_LOW_ON THEN
3163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: start time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
3164: END IF;
3165:
3166: INSERT INTO OZF_SD_BATCH_LINES_ALL
3167: (batch_line_id,
3168: object_version_number,
3169: batch_id,
3170: batch_line_number,

Line 3308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');

3304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert into batch lines: end time:' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
3305: END IF;
3306:
3307: IF OZF_DEBUG_LOW_ON THEN
3308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');
3309: END IF;
3310:
3311: l_batch_line_number := l_batch_line_number + 1;
3312: END IF;

Line 3378: FROM ozf_sd_batch_lines_all

3374: last_updated_by = FND_GLOBAL.USER_ID,
3375: object_version_number = object_version_number + 1
3376: WHERE utilization_id in
3377: (SELECT utilization_id
3378: FROM ozf_sd_batch_lines_all
3379: WHERE batch_id = l_batch_id);
3380: EXCEPTION
3381: WHEN OTHERS THEN
3382: IF OZF_DEBUG_HIGH_ON THEN

Line 3436: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '

3432: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start INVOKE_BATCH_AUTO_CLAIM ---');
3433: END IF;
3434:
3435: l_sql := 'SELECT HDR.BATCH_ID, HDR.vendor_site_id, HDR.BATCH_SUBMISSION_DATE '
3436: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '
3437: || ' WHERE HDR.batch_id = BLN.batch_id'
3438: || ' AND HDR.status_code = ''SUBMITTED'' ';
3439:
3440:

Line 3765: FROM ozf_sd_batch_headers_all HDR , ozf_sd_batch_lines_all BLN

3761: l_func_currency VARCHAR2(15);
3762:
3763: CURSOR get_sd_batches_pending_claim(c_org_id NUMBER,c_vendor_id NUMBER,c_vendor_site_id NUMBER,c_batch_id NUMBER) IS
3764: SELECT HDR.BATCH_ID batch_id, HDR.CURRENCY_CODE currency_code
3765: FROM ozf_sd_batch_headers_all HDR , ozf_sd_batch_lines_all BLN
3766: WHERE HDR.batch_id = BLN.batch_id
3767: AND HDR.status_code = 'PENDING_CLAIM'
3768: AND HDR.org_id = NVL(c_org_id,HDR.org_id)
3769: AND HDR.vendor_id = NVL(c_vendor_id,HDR.vendor_id)

Line 3798: UPDATE ozf_sd_batch_lines_all BLN

3794: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Initiating claim for batch '|| batch_rec.BATCH_ID);
3795:
3796: SAVEPOINT BEFORE_INVOKE_CLAIM;
3797:
3798: UPDATE ozf_sd_batch_lines_all BLN
3799: SET batch_curr_claim_amount = (
3800: CASE
3801:
3802: WHEN ((BLN.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,

Line 3833: FROM ozf_sd_batch_lines_all BLN,

3829: last_update_date = sysdate,
3830: last_updated_by = fnd_global.user_id
3831: WHERE batch_id = batch_rec.batch_id
3832: AND batch_line_number IN (SELECT BLN.BATCH_LINE_NUMBER
3833: FROM ozf_sd_batch_lines_all BLN,
3834: ozf_funds_utilized_all_b FU
3835: WHERE BLN.batch_id = batch_rec.BATCH_ID
3836: AND BLN.utilization_id = FU.utilization_id
3837: AND ((batch_rec.currency_code <> BLN.claim_amount_currency_code) AND (batch_rec.currency_code <> l_func_currency))