APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_ALL

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 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 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 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 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''