APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_ALL

Line 378: FROM ozf_resale_lines_all b

374: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
375: 'SELLING_PRICE',
376: NULL,
377: b.org_id
378: FROM ozf_resale_lines_all b
379: , ozf_resale_batch_line_maps_all c
380: WHERE b.direct_customer_flag = 'T'
381: AND b.selling_price IS NULL
382: AND b.resale_line_id = c.resale_line_id

Line 445: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,

441: -- It creates resale lines and accruals based on the discount information.
442: --
443: -- PARAMETERS
444: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
445: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,
446: -- p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
447: -- p_header_id IN NUMBER,
448: -- p_resale_batch_id IN NUMBER,
449: -- p_inventory_tracking IN BOOLEAN,

Line 1326: , ozf_resale_lines_all c

1322: ) IS
1323: SELECT a.resale_header_id
1324: FROM ozf_resale_headers_all a
1325: , ozf_resale_lines_int_all b
1326: , ozf_resale_lines_all c
1327: WHERE b.resale_batch_id = p_id
1328: AND b.order_number = p_order_number
1329: AND b.bill_to_cust_account_id = p_cust_id
1330: AND b.date_ordered = p_date

Line 1833: , ozf_resale_lines_all b

1829: , a.header_attribute13
1830: , a.header_attribute14
1831: , a.header_attribute15
1832: FROM ozf_resale_headers_all a
1833: , ozf_resale_lines_all b
1834: , ozf_resale_batch_line_maps_all c
1835: WHERE a.resale_header_id = b.resale_header_id
1836: AND b.resale_line_id = c.resale_line_id
1837: AND c.resale_batch_id = p_resale_batch_id;