APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_RESALE_LINES_ALL

Line 7822: FROM OZF_RESALE_LINES_ALL

7818: NVL(date_shipped, date_ordered) actual_shipment_date,
7819: NVL(date_shipped, date_ordered) fulfillment_date, -- invoiced date ?????
7820: inventory_item_id,
7821: currency_code --dummy column
7822: FROM OZF_RESALE_LINES_ALL
7823: WHERE resale_line_id = p_resale_line_id;
7824: */
7825: ----- fix bug 5671169
7826: SELECT line.quantity ordered_quantity ,

Line 7840: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj

7836: line.uom_code, -- Catch Weight ER : dummy column
7837: line.quantity, -- Catch Weight ER : dummy column
7838: line.uom_code, -- Catch Weight ER : dummy column
7839: NULL -- Catch Weight ER : dummy column
7840: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj
7841: WHERE line.resale_line_id = p_resale_line_id
7842: AND adj.resale_adjustment_id = p_adj_id
7843: AND line.resale_line_id = adj.resale_line_id;
7844:

Line 8986: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj

8982: NVL(line.date_shipped, line.date_ordered) fulfillment_date, -- invoiced date ?????
8983: line.inventory_item_id,
8984: line.currency_code, --dummy column
8985: line.resale_header_id
8986: FROM OZF_RESALE_LINES_ALL line,ozf_resale_adjustments_all adj
8987: WHERE line.resale_line_id = p_resale_line_id
8988: AND adj.resale_adjustment_id = p_adj_id
8989: AND line.resale_line_id = adj.resale_line_id;
8990: