APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_RESALE_LINES_ALL

Line 3771: FROM OZF_RESALE_LINES_ALL

3767: NVL(date_shipped, date_ordered) actual_shipment_date,
3768: NVL(date_shipped, date_ordered) fulfillment_date, -- invoiced date ?????
3769: inventory_item_id,
3770: currency_code --dummy column
3771: FROM OZF_RESALE_LINES_ALL
3772: WHERE resale_line_id = p_resale_line_id;
3773: */
3774: ----- fix bug 5671169
3775: SELECT line.quantity ordered_quantity ,

Line 3784: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj

3780: NVL(line.date_shipped, line.date_ordered) actual_shipment_date,
3781: NVL(line.date_shipped, line.date_ordered) fulfillment_date, -- invoiced date ?????
3782: line.inventory_item_id,
3783: line.currency_code --dummy column
3784: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj
3785: WHERE line.resale_line_id = p_resale_line_id
3786: AND adj.resale_adjustment_id = p_adj_id
3787: AND line.resale_line_id = adj.resale_line_id;
3788:

Line 4696: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj

4692: NVL(line.date_shipped, line.date_ordered) fulfillment_date, -- invoiced date ?????
4693: line.inventory_item_id,
4694: line.currency_code, --dummy column
4695: line.resale_header_id
4696: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj
4697: WHERE line.resale_line_id = p_resale_line_id
4698: AND adj.resale_adjustment_id = p_adj_id
4699: AND line.resale_line_id = adj.resale_line_id;
4700: