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_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 217: -- This procedure checks null values from ozf_resale_lines_int_all table

213: -- PROCEDURE
214: -- Log_Null_Values
215: --
216: -- PURPOSE
217: -- This procedure checks null values from ozf_resale_lines_int_all table
218: --
219: -- PARAMETERS
220: --
221: --

Line 248: FROM ozf_resale_lines_int_all

244: WHERE resale_batch_id = p_id;
245: -- bugfix
246: CURSOR null_columns_csr (p_start_date IN DATE, p_end_date IN DATE) IS
247: SELECT resale_line_int_id, 'OZF_RESALE_ORD_NUM_MISS', 'ORDER_NUMBER', NULL
248: FROM ozf_resale_lines_int_all
249: WHERE resale_batch_id = p_batch_id
250: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
251: AND order_number IS NULL
252: UNION ALL

Line 254: FROM ozf_resale_lines_int_all

250: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
251: AND order_number IS NULL
252: UNION ALL
253: SELECT resale_line_int_id, 'OZF_RESALE_ORD_DATE_MISS', 'DATE_ORDERED', NULL
254: FROM ozf_resale_lines_int_all
255: WHERE resale_batch_id = p_batch_id
256: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
257: AND date_ordered IS NULL
258: UNION ALL

Line 260: FROM ozf_resale_lines_int_all

256: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
257: AND date_ordered IS NULL
258: UNION ALL
259: SELECT resale_line_int_id, 'OZF_ORD_DATE_LT_START', 'DATE_ORDERED', TO_CHAR(date_ordered)
260: FROM ozf_resale_lines_int_all
261: WHERE resale_batch_id = p_batch_id
262: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
263: AND date_ordered IS NOT NULL
264: AND date_ordered < p_start_date

Line 267: FROM ozf_resale_lines_int_all

263: AND date_ordered IS NOT NULL
264: AND date_ordered < p_start_date
265: UNION ALL
266: SELECT resale_line_int_id, 'OZF_ORD_DATE_GT_END', 'DATE_ORDERED', TO_CHAR(date_ordered)
267: FROM ozf_resale_lines_int_all
268: WHERE resale_batch_id = p_batch_id
269: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
270: AND date_ordered IS NOT NULL
271: AND date_ordered > p_end_date

Line 274: FROM ozf_resale_lines_int_all

270: AND date_ordered IS NOT NULL
271: AND date_ordered > p_end_date
272: UNION ALL
273: SELECT resale_line_int_id, 'OZF_RESALE_PRODUCT_ID_MISS', 'INVENTORY_ITEM_ID', NULL
274: FROM ozf_resale_lines_int_all
275: WHERE resale_batch_id = p_batch_id
276: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
277: AND inventory_item_id IS NULL
278: UNION ALL

Line 280: FROM ozf_resale_lines_int_all

276: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
277: AND inventory_item_id IS NULL
278: UNION ALL
279: SELECT resale_line_int_id, 'OZF_RESALE_UOM_MISS', 'UOM_CODE', NULL
280: FROM ozf_resale_lines_int_all
281: WHERE resale_batch_id = p_batch_id
282: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
283: AND uom_code IS NULL
284: UNION ALL

Line 286: FROM ozf_resale_lines_int_all

282: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
283: AND uom_code IS NULL
284: UNION ALL
285: SELECT resale_line_int_id, 'OZF_RESALE_SOLD_FROM_MISS', 'SOLD_FROM_CUST_ACCOUNT_ID', NULL
286: FROM ozf_resale_lines_int_all
287: WHERE resale_batch_id = p_batch_id
288: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
289: AND sold_from_cust_account_id IS NULL
290: UNION ALL

Line 292: FROM ozf_resale_lines_int_all

288: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
289: AND sold_from_cust_account_id IS NULL
290: UNION ALL
291: SELECT resale_line_int_id, 'OZF_RESALE_SHIP_FROM_MISS', 'SHIP_FROM_CUST_ACCOUNT_ID', NULL
292: FROM ozf_resale_lines_int_all
293: WHERE resale_batch_id = p_batch_id
294: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
295: AND ship_from_cust_account_id IS NULL
296: UNION ALL

Line 298: FROM ozf_resale_lines_int_all

294: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
295: AND ship_from_cust_account_id IS NULL
296: UNION ALL
297: SELECT resale_line_int_id, 'OZF_RESALE_PRICE_LIST_NULL', 'AGREEMENT_ID', NULL
298: FROM ozf_resale_lines_int_all
299: WHERE resale_batch_id = p_batch_id
300: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
301: AND agreement_type = 'PL'
302: AND agreement_id IS NULL

Line 305: FROM ozf_resale_lines_int_all

301: AND agreement_type = 'PL'
302: AND agreement_id IS NULL
303: UNION ALL
304: SELECT resale_line_int_id, 'OZF_RESALE_AGREE_NUM_NULL', 'AGREEMENT_ID', NULL
305: FROM ozf_resale_lines_int_all
306: WHERE resale_batch_id = p_batch_id
307: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
308: AND agreement_type = 'SPO'
309: AND agreement_id IS NULL;

Line 370: -- This procedure checks invalid values from ozf_resale_lines_int_all table

366: -- PROCEDURE
367: -- Log_Invalid_Values
368: --
369: -- PURPOSE
370: -- This procedure checks invalid values from ozf_resale_lines_int_all table
371: --
372: -- PARAMETERS
373: --
374: -- NOTES:

Line 395: FROM ozf_resale_lines_int_all orsl

391: SELECT orsl.resale_line_int_id
392: , 'OZF_CLAIM_CUST_NOT_IN_DB'
393: , 'SOLD_FROM_CUST_ACCOUNT_ID'
394: , to_char(orsl.sold_from_cust_account_id)
395: FROM ozf_resale_lines_int_all orsl
396: WHERE orsl.status_code = 'OPEN'
397: AND orsl.direct_customer_flag = 'T'
398: AND orsl.resale_batch_id = p_resale_batch_id
399: AND orsl.sold_from_cust_account_id IS NOT NULL

Line 408: FROM ozf_resale_lines_int_all orsl

404: SELECT orsl.resale_line_int_id
405: , 'OZF_CLAIM_CUST_NOT_IN_DB'
406: , 'SHIP_FROM_CUST_ACCOUNT_ID'
407: , to_char(orsl.ship_from_cust_account_id)
408: FROM ozf_resale_lines_int_all orsl
409: WHERE orsl.status_code = 'OPEN'
410: AND orsl.direct_customer_flag = 'T'
411: AND orsl.resale_batch_id = p_resale_batch_id
412: AND orsl.ship_from_cust_account_id IS NOT NULL

Line 421: FROM ozf_resale_lines_int_all orsl

417: SELECT orsl.resale_line_int_id
418: , 'OZF_RESALE_UOM_NOT_IN_DB'
419: , 'UOM_CODE'
420: , orsl.uom_code
421: FROM ozf_resale_lines_int_all orsl
422: WHERE orsl.direct_customer_flag ='T'
423: AND orsl.status_code = 'OPEN'
424: AND orsl.resale_batch_id = p_resale_batch_id
425: AND orsl.uom_code IS NOT NULL

Line 434: FROM ozf_resale_lines_int_all orsl

430: SELECT orsl.resale_line_int_id
431: , 'OZF_RESALE_ORDTYPE_NOT_IN_DB'
432: , 'ORDER_TYPE_ID'
433: , to_char(orsl.order_type_id)
434: FROM ozf_resale_lines_int_all orsl
435: WHERE orsl.status_code = 'OPEN'
436: AND orsl.direct_customer_flag = 'T'
437: AND orsl.order_type_id IS NOT NULL
438: AND orsl.resale_batch_id = p_resale_batch_id

Line 448: FROM ozf_resale_lines_int_all orsl

444: SELECT orsl.resale_line_int_id
445: , 'OZF_RESALE_PRICE_NOT_IN_DB'
446: , 'AGREEMENT_ID'
447: , to_char(orsl.agreement_id)
448: FROM ozf_resale_lines_int_all orsl
449: WHERE orsl.status_code = 'OPEN'
450: AND orsl.direct_customer_flag = 'T'
451: AND orsl.resale_batch_id = p_resale_batch_id
452: AND orsl.agreement_id IS NOT NULL

Line 463: FROM ozf_resale_lines_int_all orsl

459: SELECT orsl.resale_line_int_id
460: , 'OZF_RESALE_PRODUCT_NOT_IN_DB'
461: , 'INVENTORY_ITEM_ID'
462: , to_char(orsl.inventory_item_id)
463: FROM ozf_resale_lines_int_all orsl
464: WHERE orsl.status_code = 'OPEN'
465: AND orsl.direct_customer_flag = 'T'
466: AND orsl.resale_batch_id = p_resale_batch_id
467: AND orsl.inventory_item_id IS NOT NULL

Line 553: UPDATE ozf_resale_lines_int_all orli

549: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
550: END IF;
551: --
552: BEGIN
553: UPDATE ozf_resale_lines_int_all orli
554: SET orli.dispute_code = (SELECT orl.error_code
555: FROM ozf_resale_logs_all orl
556: WHERE orl.resale_id = orli.resale_line_int_id
557: AND resale_id_type = 'IFACE'

Line 661: FROM ozf_resale_lines_int_all

657:
658: CURSOR csr_duplicated_dispute_amount(p_resale_batch_id IN NUMBER) IS
659: SELECT NVL(COUNT(resale_line_int_id), 0)
660: , NVL(SUM(total_claimed_amount), 0)
661: FROM ozf_resale_lines_int_all
662: WHERE resale_batch_id = p_resale_batch_id
663: AND status_code = 'DUPLICATED';
664:
665: BEGIN

Line 1033: UPDATE ozf_resale_lines_int_all

1029: l_total_allowed_amount := p_allowed_amount * ABS(p_line_quantity);
1030: END IF;
1031: -- bug 5969118 end
1032:
1033: UPDATE ozf_resale_lines_int_all
1034: SET accepted_amount = l_accepted_amount,
1035: -- total_accepted_amount = l_accepted_amount * ABS(p_line_quantity),
1036: -- bug 5969118 Ship and Debit return order generates positive claim amount
1037: total_accepted_amount = l_total_accepted_amount,

Line 1129: ozf_resale_lines_int_all orli

1125: IS
1126: SELECT orl.resale_line_id
1127: -- Bug 4670154 (+)
1128: FROM ozf_resale_lines_all orl,
1129: ozf_resale_lines_int_all orli
1130: /*
1131: FROM ozf_resale_lines orl,
1132: ozf_resale_lines_int orli
1133: */

Line 1159: ozf_resale_lines_int_all orli

1155: IS
1156: SELECT orl.resale_line_id
1157: -- Bug 4670154 (+)
1158: FROM ozf_resale_lines_all orl,
1159: ozf_resale_lines_int_all orli
1160: /*
1161: FROM ozf_resale_lines orl,
1162: ozf_resale_lines_int orli
1163: */

Line 1210: FROM ozf_resale_lines_int_all orlo,

1206: CURSOR dup_line_direct_iface_csr ( p_resale_line_int_id IN NUMBER )
1207: IS
1208: SELECT orlo.resale_line_int_id
1209: -- Bug 4670154 (+)
1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli

Line 1211: ozf_resale_lines_int_all orli

1207: IS
1208: SELECT orlo.resale_line_int_id
1209: -- Bug 4670154 (+)
1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli
1215: */

Line 1245: FROM ozf_resale_lines_int_all orlo,

1241: CURSOR dup_line_indirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1242: IS
1243: SELECT orlo.resale_line_int_id
1244: -- Bug 4670154 (+)
1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli

Line 1246: ozf_resale_lines_int_all orli

1242: IS
1243: SELECT orlo.resale_line_int_id
1244: -- Bug 4670154 (+)
1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli
1250: */

Line 1282: ozf_resale_lines_int_all orli

1278: CURSOR dup_line_nondirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1279: IS
1280: SELECT orl.resale_line_id
1281: FROM ozf_resale_lines_all orl,
1282: ozf_resale_lines_int_all orli
1283: -- Bug 4670154 (+)
1284: /*
1285: FROM ozf_resale_lines orl,
1286: ozf_resale_lines_int orli

Line 1313: FROM ozf_resale_lines_int_all orlo,

1309: CURSOR dup_line_nondirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1310: IS
1311: SELECT orlo.resale_line_int_id
1312: -- Bug 4670154 (+)
1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli

Line 1314: ozf_resale_lines_int_all orli

1310: IS
1311: SELECT orlo.resale_line_int_id
1312: -- Bug 4670154 (+)
1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli
1318: */

Line 1349: FROM ozf_resale_lines_int_all orlo,

1345:
1346: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1347: IS
1348: SELECT orlo.resale_line_int_id
1349: FROM ozf_resale_lines_int_all orlo,
1350: ozf_resale_lines_int_all orli
1351: WHERE orlo.order_number = orli.order_number
1352: AND orlo.date_ordered = orli.date_ordered
1353: -- 6704619 (+)

Line 1350: ozf_resale_lines_int_all orli

1346: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1347: IS
1348: SELECT orlo.resale_line_int_id
1349: FROM ozf_resale_lines_int_all orlo,
1350: ozf_resale_lines_int_all orli
1351: WHERE orlo.order_number = orli.order_number
1352: AND orlo.date_ordered = orli.date_ordered
1353: -- 6704619 (+)
1354: AND (orlo.date_shipped = orli.date_shipped

Line 1377: FROM ozf_resale_lines_int_all orlo,

1373:
1374: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1375: IS
1376: SELECT orlo.resale_line_int_id
1377: FROM ozf_resale_lines_int_all orlo,
1378: ozf_resale_lines_int_all orli
1379: WHERE orlo.order_number = orli.order_number
1380: AND orlo.date_ordered = orli.date_ordered
1381: -- 6704619 (+)

Line 1378: ozf_resale_lines_int_all orli

1374: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1375: IS
1376: SELECT orlo.resale_line_int_id
1377: FROM ozf_resale_lines_int_all orlo,
1378: ozf_resale_lines_int_all orli
1379: WHERE orlo.order_number = orli.order_number
1380: AND orlo.date_ordered = orli.date_ordered
1381: -- 6704619 (+)
1382: AND (orlo.date_shipped = orli.date_shipped

Line 1406: FROM ozf_resale_lines_int_all orlo,

1402:
1403: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1404: IS
1405: SELECT orlo.resale_line_int_id
1406: FROM ozf_resale_lines_int_all orlo,
1407: ozf_resale_lines_int_all orli
1408: WHERE orlo.order_number = orli.order_number
1409: AND orlo.date_ordered = orli.date_ordered
1410: -- 6704619 (+)

Line 1407: ozf_resale_lines_int_all orli

1403: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1404: IS
1405: SELECT orlo.resale_line_int_id
1406: FROM ozf_resale_lines_int_all orlo,
1407: ozf_resale_lines_int_all orli
1408: WHERE orlo.order_number = orli.order_number
1409: AND orlo.date_ordered = orli.date_ordered
1410: -- 6704619 (+)
1411: AND (orlo.date_shipped = orli.date_shipped

Line 1698: UPDATE ozf_resale_lines_int_all

1694: IF l_open_lines_tbl.EXISTS(1) THEN
1695: FOR i IN 1..l_open_lines_tbl.LAST
1696: LOOP
1697: -- BUG 4670154 (+)
1698: UPDATE ozf_resale_lines_int_all
1699: SET duplicated_line_id = NULL
1700: , duplicated_adjustment_id = NULL
1701: WHERE resale_line_int_id = l_open_lines_tbl(i);
1702: -- BUG 4670154 (-)

Line 2613: UPDATE ozf_resale_lines_int_all

2609: RAISE FND_API.g_exc_unexpected_error;
2610: END IF;
2611:
2612: -- update the interface duplicated line
2613: UPDATE ozf_resale_lines_int_all
2614: SET duplicated_line_id = p_line_id
2615: , duplicated_adjustment_id =l_adjustment_id
2616: WHERE duplicated_line_id = p_line_int_rec.resale_line_int_id
2617: AND duplicated_adjustment_id = -1;

Line 3178: UPDATE ozf_resale_lines_int_all

3174: END IF;
3175: ELSE
3176: -- This IS a duplicate. No need to create utilization
3177: -- SLKRISHN move update to resale common pvt
3178: UPDATE ozf_resale_lines_int_all
3179: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED,
3180: duplicated_line_id = p_line_id,
3181: duplicated_adjustment_id = l_dup_adjustment_id
3182: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;