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_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES

Line 351: FROM ozf_resale_lines_int_all b

347: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
348: 'SELLING_PRICE',
349: NULL,
350: org_id
351: FROM ozf_resale_lines_int_all b
352: WHERE b.status_code = 'OPEN'
353: AND b.direct_customer_flag = 'T'
354: AND b.selling_price IS NULL
355: AND b.resale_batch_id = p_resale_batch_id

Line 370: UPDATE ozf_resale_lines_int_all

366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END;
368:
369: BEGIN
370: UPDATE ozf_resale_lines_int_all
371: SET status_code = 'DISPUTED',
372: dispute_code = 'OZF_RESALE_SELL_PRICE_NULL'
373: WHERE status_code = 'OPEN'
374: AND direct_customer_flag = 'T'

Line 403: FROM ozf_resale_lines_all b

399: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
400: 'SELLING_PRICE',
401: NULL,
402: b.org_id
403: FROM ozf_resale_lines_all b
404: , ozf_resale_batch_line_maps_all c
405: WHERE b.direct_customer_flag = 'T'
406: AND b.selling_price IS NULL
407: AND b.resale_line_id = c.resale_line_id

Line 471: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,

467: -- It creates resale lines and accruals based on the discount information.
468: --
469: -- PARAMETERS
470: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
471: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,
472: -- p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
473: -- p_header_id IN NUMBER,
474: -- p_resale_batch_id IN NUMBER,
475: -- p_inventory_tracking IN BOOLEAN,

Line 493: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,

489:
490:
491: PROCEDURE Process_One_Line(
492: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
493: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
494: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
495: p_header_id IN NUMBER,
496: p_resale_batch_id IN NUMBER,
497: p_inventory_tracking IN BOOLEAN,

Line 553: l_line_int_rec OZF_RESALE_LINES_INT%rowtype;

549:
550: l_is_valid_offer BOOLEAN;
551: l_price_diff_util BOOLEAN;
552: l_object_type VARCHAR2(30);
553: l_line_int_rec OZF_RESALE_LINES_INT%rowtype;
554:
555: l_rate NUMBER;
556: l_exchange_type VARCHAR2(30);
557: l_to_create_utilization BOOLEAN;

Line 613: FROM ozf_resale_lines_all

609: AND off.qp_list_header_id = qp.list_header_id;
610:
611: CURSOR c_purchase_price(p_resale_line_id number) is
612: SELECT supplier_item_cost
613: FROM ozf_resale_lines_all
614: WHERE resale_line_id = p_resale_line_id;
615:
616: CURSOR c_sd_request_header_id(p_list_header_id IN NUMBER) IS
617: SELECT request_header_id

Line 1514: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,

1510: END process_one_line;
1511:
1512: PROCEDURE Process_One_Line(
1513: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
1514: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
1515: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
1516: p_header_id IN NUMBER,
1517: p_resale_batch_id IN NUMBER,
1518: p_inventory_tracking IN BOOLEAN,

Line 1553: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,

1549: );
1550: END Process_One_Line;
1551: PROCEDURE Process_One_Line(
1552: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
1553: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
1554: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
1555: p_header_id IN NUMBER,
1556: p_resale_batch_id IN NUMBER,
1557: p_inventory_tracking IN BOOLEAN,

Line 1633: FROM ozf_resale_lines_int_all

1629: CURSOR order_identifiers_csr (p_id IN NUMBER) IS
1630: SELECT order_number
1631: , bill_to_cust_account_id
1632: , date_ordered
1633: FROM ozf_resale_lines_int_all
1634: WHERE resale_line_int_id = p_id;
1635:
1636: CURSOR resale_info_csr (p_id IN NUMBER) IS
1637: SELECT resale_header_id

Line 1638: FROM ozf_resale_lines

1634: WHERE resale_line_int_id = p_id;
1635:
1636: CURSOR resale_info_csr (p_id IN NUMBER) IS
1637: SELECT resale_header_id
1638: FROM ozf_resale_lines
1639: WHERE resale_line_id = p_id;
1640:
1641: l_order_number VARCHAR2(30);
1642: l_cust_account_id NUMBER;

Line 1650: FROM ozf_resale_lines

1646: l_log_id NUMBER;
1647:
1648: CURSOR resale_rec_csr (p_id IN NUMBER) IS
1649: SELECT *
1650: FROM ozf_resale_lines
1651: WHERE resale_line_id = p_id;
1652:
1653: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;
1654: l_resale_rec OZF_RESALE_LINES%rowtype;

Line 1654: l_resale_rec OZF_RESALE_LINES%rowtype;

1650: FROM ozf_resale_lines
1651: WHERE resale_line_id = p_id;
1652:
1653: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;
1654: l_resale_rec OZF_RESALE_LINES%rowtype;
1655:
1656: l_header_id NUMBER;
1657: l_line_id NUMBER;
1658:

Line 1688: FROM ozf_resale_lines_int_all

1684: , p_cust_id IN NUMBER
1685: , p_date IN DATE
1686: ) IS
1687: SELECT 1
1688: FROM ozf_resale_lines_int_all
1689: WHERE resale_batch_id = p_id
1690: AND order_number = p_order_number
1691: AND bill_to_cust_account_id = p_cust_id
1692: AND date_ordered = p_date

Line 1710: , ozf_resale_lines_int_all b

1706: , p_date IN DATE
1707: ) IS
1708: SELECT a.resale_header_id
1709: FROM ozf_resale_headers_all a
1710: , ozf_resale_lines_int_all b
1711: , ozf_resale_lines_all c
1712: WHERE b.resale_batch_id = p_id
1713: AND b.order_number = p_order_number
1714: AND b.bill_to_cust_account_id = p_cust_id

Line 1711: , ozf_resale_lines_all c

1707: ) IS
1708: SELECT a.resale_header_id
1709: FROM ozf_resale_headers_all a
1710: , ozf_resale_lines_int_all b
1711: , ozf_resale_lines_all c
1712: WHERE b.resale_batch_id = p_id
1713: AND b.order_number = p_order_number
1714: AND b.bill_to_cust_account_id = p_cust_id
1715: AND b.date_ordered = p_date

Line 1801: UPDATE ozf_resale_lines_int_all

1797: -- IF there is an error for a line or lines, we need to UPDATE the whole order as error;
1798: -- nothing to UPDATE if it's FROM line.
1799: IF p_caller_type = 'IFACE' THEN
1800: BEGIN
1801: UPDATE ozf_resale_lines_int_all
1802: SET status_code = 'DISPUTED'
1803: WHERE status_code = 'OPEN'
1804: AND order_NUMBER = l_order_number
1805: AND bill_to_cust_account_id = l_cust_account_id

Line 1999: UPDATE ozf_resale_lines_int_all

1995: RAISE FND_API.g_exc_unexpected_error;
1996: END IF;
1997:
1998: -- Delink resale interface line from batch
1999: UPDATE ozf_resale_lines_int_all
2000: SET resale_batch_id = null,
2001: request_id = null,
2002: status_code = 'DISPUTED',
2003: dispute_code = 'OZF_LT_INVT'

Line 2167: UPDATE ozf_resale_lines_int_all

2163: -- drop this line from batch if it is from interface
2164: -- Fux for bug Bug 14584673 : Added exception block at the end of the loop to log all type of errors at one place.
2165: /* IF p_caller_type = 'IFACE' THEN
2166: BEGIN
2167: UPDATE ozf_resale_lines_int_all
2168: SET resale_batch_id = NULL,
2169: request_id = NULL,
2170: status_code = 'DISPUTED',
2171: dispute_code = 'OZF_PRIC_RESULT_ERR'

Line 2183: UPDATE ozf_resale_lines_int_all

2179: ELSE
2180: -- CLOSE THIS LINE If it is from interface
2181: IF p_caller_type = 'IFACE' THEN
2182: BEGIN
2183: UPDATE ozf_resale_lines_int_all
2184: SET status_code= 'CLOSED'
2185: WHERE resale_line_int_id = p_line_tbl(i).chargeback_int_id;
2186: EXCEPTION
2187: WHEN OTHERS THEN

Line 2219: UPDATE ozf_resale_lines_int_all

2215: RAISE FND_API.g_exc_unexpected_error;
2216: END IF;
2217: IF p_run_mode <> 'DRAFT' THEN
2218: -- Delink resale interface line from batch
2219: UPDATE ozf_resale_lines_int_all
2220: SET resale_batch_id = null,
2221: request_id = null,
2222: status_code = 'DISPUTED',
2223: dispute_code = l_dispute_code

Line 2226: UPDATE ozf_resale_lines_int_all

2222: status_code = 'DISPUTED',
2223: dispute_code = l_dispute_code
2224: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
2225: ELSE
2226: UPDATE ozf_resale_lines_int_all
2227: SET status_code = 'DISPUTED',
2228: dispute_code = l_dispute_code
2229: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
2230: END IF;

Line 2355: , ozf_resale_lines_all b

2351: , a.header_attribute13
2352: , a.header_attribute14
2353: , a.header_attribute15
2354: FROM ozf_resale_headers_all a
2355: , ozf_resale_lines_all b
2356: , ozf_resale_batch_line_maps_all c
2357: WHERE a.resale_header_id = b.resale_header_id
2358: AND b.resale_line_id = c.resale_line_id
2359: AND c.resale_batch_id = p_resale_batch_id;

Line 2373: FROM ozf_resale_lines

2369: l_header_rec order_header_csr%rowtype;
2370:
2371: CURSOR order_set_csr(p_header_id in NUMBER) IS
2372: SELECT *
2373: FROM ozf_resale_lines
2374: WHERE resale_header_id = p_header_id;
2375:
2376: TYPE resale_lines_tbl_type is TABLE OF order_set_csr%rowtype INDEX BY binary_integer;
2377: l_order_set_tbl resale_lines_tbl_type;

Line 3241: FROM ozf_resale_lines_int

3237: CURSOR order_num_csr is
3238: SELECT distinct order_NUMBER,
3239: bill_to_cust_account_id,
3240: date_ordered
3241: FROM ozf_resale_lines_int
3242: WHERE status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3243: AND direct_customer_flag = 'F'
3244: AND resale_batch_id = p_resale_batch_id
3245: ORDER BY date_ordered;

Line 3255: FROM ozf_resale_lines_int

3251: CURSOR interface_rec_csr(p_num in VARCHAR2,
3252: p_name in VARCHAR2,
3253: p_date in date) IS
3254: SELECT *
3255: FROM ozf_resale_lines_int
3256: WHERE order_NUMBER = p_num
3257: AND bill_to_cust_account_id = p_name
3258: AND date_ordered = p_date
3259: AND direct_customer_flag ='F'

Line 3352: FROM ozf_resale_lines_int_all b

3348: DELETE FROM ozf_resale_logs_all a
3349: WHERE a.resale_id_type = 'IFACE'
3350: AND a.resale_id IN (
3351: SELECT resale_line_int_id
3352: FROM ozf_resale_lines_int_all b
3353: WHERE b.direct_customer_flag = 'F'
3354: AND b.status_code = 'OPEN'
3355: AND b.order_number = l_order_num_tbl(i).order_number
3356: AND b.bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 3405: UPDATE ozf_resale_lines_int

3401: END IF;
3402: END LOOP;
3403:
3404: BEGIN
3405: UPDATE ozf_resale_lines_int
3406: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
3407: WHERE direct_customer_flag ='F'
3408: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3409: AND resale_batch_id = p_resale_batch_id;

Line 3496: FROM ozf_resale_lines_int_all

3492: CURSOR order_num_csr IS
3493: SELECT DISTINCT order_NUMBER,
3494: bill_to_cust_account_id,
3495: date_ordered
3496: FROM ozf_resale_lines_int_all
3497: WHERE status_code IN ('OPEN', 'DUPLICATED')
3498: AND duplicated_adjustment_id IS NULL
3499: AND resale_batch_id = p_resale_batch_id
3500: AND direct_customer_flag <> 'F' -- TPA in DRAFT mode ER : will pick up only the direct customer orders

Line 3513: FROM ozf_resale_lines_int_all

3509: p_id IN NUMBER,
3510: p_date IN DATE
3511: ) IS
3512: SELECT *
3513: FROM ozf_resale_lines_int_all
3514: WHERE order_number = p_order_number
3515: AND bill_to_cust_account_id= p_id
3516: AND date_ordered = p_date
3517: AND status_code IN ('OPEN', 'DUPLICATED')

Line 3551: FROM ozf_resale_lines_int_all

3547: p_id IN NUMBER,
3548: p_date IN DATE
3549: ) IS
3550: SELECT *
3551: FROM ozf_resale_lines_int_all
3552: WHERE order_number = p_order_number
3553: AND bill_to_cust_account_id = p_id
3554: AND date_ordered = p_date
3555: AND status_code = 'DUPLICATED'

Line 3565: FROM ozf_resale_lines_int_all

3561: p_id IN NUMBER,
3562: p_date IN DATE
3563: ) IS
3564: SELECT *
3565: FROM ozf_resale_lines_int_all
3566: WHERE order_number = p_order_number -- ?? need this
3567: AND bill_to_cust_account_id = p_id -- ?? need this
3568: AND date_ordered = p_date
3569: AND status_code IN ('OPEN', 'DUPLICATED')

Line 3576: FROM ozf_resale_lines_int_all

3572:
3573: -- [BEGIN OF BUG 4233341 FIXING]
3574: CURSOR csr_valid_line_count(cv_batch_id IN NUMBER) IS
3575: SELECT COUNT(1)
3576: FROM ozf_resale_lines_int_all
3577: WHERE status_code IN ('PROCESSED', 'CLOSED', 'DUPLICATED')
3578: AND resale_batch_id = cv_batch_id;
3579:
3580: CURSOR csr_get_batch_number(cv_batch_id IN NUMBER) IS

Line 3595: FROM ozf_resale_lines_int_all i

3591: , lk.meaning dispute_code
3592: , lg.error_message
3593: , lg.column_name
3594: , lg.column_value
3595: FROM ozf_resale_lines_int_all i
3596: , ozf_resale_logs_all lg
3597: , ozf_lookups lk
3598: WHERE i.dispute_code = lk.lookup_code(+)
3599: AND lk.lookup_type(+) = 'OZF_RESALE_DISPUTE_CODE'

Line 3610: FROM ozf_resale_lines_int_all i

3606: CURSOR csr_out_duplicate_pre_proc(cv_batch_id IN NUMBER) IS
3607: SELECT i.resale_line_int_id id
3608: , DECODE(lg.column_value,'-1', 'RESALE_LINE_INT_ID', '-2', 'RESALE_LINE_ID') column_name
3609: , i.duplicated_line_id column_value
3610: FROM ozf_resale_lines_int_all i
3611: , ozf_resale_logs_all lg
3612: WHERE i.status_code = 'DUPLICATED'
3613: AND i.resale_batch_id = cv_batch_id
3614: AND i.resale_line_int_id = lg.resale_id

Line 3772: UPDATE ozf_resale_lines_int

3768:
3769: -- Bug 14194884 - TPA In Draft Mode ER : Indirect Orders to be processed only in FINAL mode
3770: IF l_run_mode = 'FINAL' THEN
3771: -- remove all the disputed lines
3772: UPDATE ozf_resale_lines_int
3773: SET resale_batch_id = null
3774: , request_id = null -- [BUG 4233341 FIXING]
3775: Where resale_batch_id = p_resale_batch_id
3776: and status_code = 'DISPUTED';

Line 3873: UPDATE ozf_resale_lines_int_all

3869: l_order_num_tbl(i).bill_to_cust_account_id IS NOT NULL AND
3870: l_order_num_tbl(i).date_ordered IS NOT NULL THEN
3871:
3872: -- UPDATE tracing order lines to processed for this order to be processed
3873: UPDATE ozf_resale_lines_int_all
3874: SET status_code= 'PROCESSED'
3875: WHERE status_code = 'OPEN'
3876: AND order_number = l_order_num_tbl(i).order_number
3877: AND bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 4166: UPDATE ozf_resale_lines_int

4162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4163: ozf_utility_pvt.error_message('OZF_GET_ORDER_PRIC_ERR');
4164:
4165: BEGIN
4166: UPDATE ozf_resale_lines_int
4167: SET status_code = 'DISPUTED'
4168: WHERE status_code = 'OPEN'
4169: AND order_number = l_order_num_tbl(i).order_number
4170: AND bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 4270: UPDATE ozf_resale_lines_int_all

4266: END;
4267: END LOOP;
4268:
4269: BEGIN
4270: UPDATE ozf_resale_lines_int_all
4271: SET status_code = 'DISPUTED'
4272: WHERE status_code = 'OPEN'
4273: AND order_number = l_order_num_tbl(i).order_number
4274: AND bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 4543: UPDATE ozf_resale_lines_int_all

4539: IF l_run_mode <> 'DRAFT' THEN
4540:
4541: -- [BEGIN OF BUG 4233341 FIXING]
4542: -- delink all the new/processed/disputed lines
4543: UPDATE ozf_resale_lines_int_all
4544: SET resale_batch_id = null
4545: , request_id = null
4546: WHERE resale_batch_id = p_resale_batch_id
4547: AND status_code IN ('NEW', 'OPEN', 'DISPUTED'); -- 'PROCESSED'

Line 4679: FROM ozf_resale_lines_int

4675: l_org_id NUMBER := MO_GLOBAL.get_current_org_id(); -- nepanda : Fix for bug # 15900683
4676:
4677: CURSOR account_id_csr (p_id NUMBER)IS
4678: SELECT distinct sold_from_cust_account_id, org_id, currency_code
4679: FROM ozf_resale_lines_int
4680: WHERE resale_batch_id IS NULL
4681: AND request_id = p_id
4682: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4683:

Line 4734: FROM ozf_resale_lines_int orli

4730: , orli.sold_from_email
4731: , orli.sold_from_phone
4732: , orli.sold_from_fax
4733: ,orli.currency_code
4734: FROM ozf_resale_lines_int orli
4735: WHERE orli.resale_batch_id IS NULL
4736: AND orli.sold_from_cust_account_id = p_id
4737: AND orli.request_id = G_CONC_REQUEST_ID
4738: AND orli.org_id = p_org_id

Line 4757: FROM ozf_resale_lines_int_all

4753: CURSOR start_end_date_csr( p_account_id NUMBER,
4754: p_org_id NUMBER,
4755: p_currency_code VARCHAR2) IS
4756: SELECT MIN(date_ordered), MAX(date_ordered)
4757: FROM ozf_resale_lines_int_all
4758: WHERE sold_from_cust_account_id = p_account_id
4759: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
4760: AND org_id = p_org_id
4761: AND currency_code = p_currency_code;

Line 4773: SELECT resale_line_int_id FROM OZF_RESALE_LINES_INT_ALL_TEMP ;

4769:
4770: -- TPA iN Draft Mode - start
4771: -- Fix for Bug 14584673
4772: /*CURSOR csr_resale_lines_int_tmp_dtls IS
4773: SELECT resale_line_int_id FROM OZF_RESALE_LINES_INT_ALL_TEMP ;
4774: l_resale_line_int_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type; */
4775:
4776: l_status VARCHAR2(5);
4777: l_industry VARCHAR2(5);

Line 4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673

4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE
4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673
4802: WHERE logs.resale_id = intDraft.resale_line_int_id
4803: AND intDraft.draft_run_id = l_draft_run_id
4804: AND intDraft.org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4805:

Line 4811: SELECT COUNT(*) FROM ozf_resale_lines_int_all

4807: l_resale_logs_tbl l_resale_logs_tbl_type;
4808:
4809: -- nepanda : Fix for bug # 15900683 : cursor to find out number of lines being fetched for an org id
4810: CURSOR csr_processed_lines_count IS
4811: SELECT COUNT(*) FROM ozf_resale_lines_int_all
4812: WHERE REQUEST_ID = G_CONC_REQUEST_ID
4813: AND ORG_ID = l_org_id ;
4814:
4815: l_processed_lines_count NUMBER;

Line 4870: UPDATE ozf_resale_lines_int_all

4866: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4867: END IF;
4868: END IF;
4869:
4870: UPDATE ozf_resale_lines_int_all
4871: SET request_id = G_CONC_REQUEST_ID
4872: , dispute_code = null
4873: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4874: , program_update_date = SYSDATE

Line 4885: UPDATE ozf_resale_lines_int_all

4881: IF OZF_DEBUG_LOW_ON THEN
4882: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4883: END IF;
4884:
4885: UPDATE ozf_resale_lines_int_all
4886: SET request_id = G_CONC_REQUEST_ID
4887: , dispute_code = null
4888: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4889: , program_update_date = SYSDATE

Line 4899: FROM ozf_resale_lines_int

4895: END IF;
4896:
4897: DELETE FROM ozf_resale_logs_all
4898: WHERE resale_id IN (SELECT resale_line_int_id
4899: FROM ozf_resale_lines_int
4900: WHERE request_id = G_CONC_REQUEST_ID
4901: AND org_id = l_org_id ) -- nepanda : Fix for bug # 15900683
4902: AND resale_id_type = 'IFACE';
4903:

Line 5057: UPDATE ozf_resale_lines_int_all orli

5053: l_batch_tbl(i) := l_resale_batch_id;
5054: l_sold_from_cust_name_tbl(i) := l_party_name;
5055: i := i +1;
5056:
5057: UPDATE ozf_resale_lines_int_all orli
5058: SET resale_batch_id = l_resale_batch_id
5059: WHERE orli.sold_from_cust_account_id = l_sold_from_cust_id_tbl(j)
5060: AND orli.org_id = l_org_id_tbl(j)
5061: AND orli.currency_code = l_currency_code_tbl(j)

Line 5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE

5086: END IF;
5087: END LOOP;
5088: END IF; -- END if l_batch_tbl.EXISTS
5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,

Line 5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id

5088: END IF; -- END if l_batch_tbl.EXISTS
5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,
5095: DRAFT_RUN_ID,
5096: RESALE_LINE_INT_ID,

Line 5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL

5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,
5095: DRAFT_RUN_ID,
5096: RESALE_LINE_INT_ID,
5097: OBJECT_VERSION_NUMBER,

Line 5327: (SELECT OZF_RESALE_LINES_INT_DRAFT_S.NEXTVAL, -- RESALE_LINES_INT_DRAFT_ID

5323: INVOICE_LINE_NUMBER,
5324: ORDER_LINE_NUMBER,
5325: SUPPLIER_ITEM_COST,
5326: SUPPLIER_ITEM_UOM)
5327: (SELECT OZF_RESALE_LINES_INT_DRAFT_S.NEXTVAL, -- RESALE_LINES_INT_DRAFT_ID
5328: l_draft_run_id, -- DRAFT_RUN_ID
5329: RESALE_LINE_INT_ID, -- RESALE_LINE_INT_ID
5330: OBJECT_VERSION_NUMBER, -- OBJECT_VERSION_NUMBER
5331: LAST_UPDATE_DATE, -- LAST_UPDATE_DATE

Line 5560: FROM OZF_RESALE_LINES_INT_ALL

5556: INVOICE_LINE_NUMBER, -- INVOICE_LINE_NUMBER
5557: ORDER_LINE_NUMBER, -- ORDER_LINE_NUMBER
5558: SUPPLIER_ITEM_COST, -- SUPPLIER_ITEM_COST
5559: SUPPLIER_ITEM_UOM -- SUPPLIER_ITEM_UOM
5560: FROM OZF_RESALE_LINES_INT_ALL
5561: WHERE REQUEST_ID = G_CONC_REQUEST_ID
5562: AND ORG_ID = l_org_id -- nepanda : Fix for bug # 15900683
5563: );
5564:

Line 5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');

5573: CLOSE csr_processed_lines_count;
5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all

Line 5581: UPDATE ozf_resale_lines_int_all

5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all
5582: SET request_id = null, resale_batch_id = null
5583: WHERE REQUEST_ID = G_CONC_REQUEST_ID
5584: AND ORG_ID = l_org_id ; -- nepanda : Fix for bug # 15900683
5585:

Line 5837: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,

5833: line.resale_line_id OrderLineId,
5834: line.quantity ShippedQuantity,
5835: (line.quantity*NVL(line.selling_price,line.purchase_price)) Revenue,
5836: NVL(util.plan_curr_amount,0) AccrualAmount
5837: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,
5838: ozf_offers off, ozf_resale_adjustments_all oe,
5839: ozf_xref_map map
5840: WHERE line.resale_line_id = util.object_id
5841: AND util.object_type = ''TP_ORDER''

Line 5861: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,

5857: util.cust_account_id CustomerId,
5858: line.quantity ShippedQuantity,
5859: (line.quantity*NVL(line.selling_price,line.purchase_price)) Revenue,
5860: NVL(util.plan_curr_amount,0) AccrualAmount
5861: FROM ozf_resale_lines_all line, ozf_funds_utilized_all_b util,
5862: ozf_offers off, ozf_resale_adjustments_all oe,
5863: ozf_xref_map map
5864: WHERE line.resale_line_id = util.object_id
5865: AND util.object_type = ''TP_ORDER''