APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_RESALE_ADJUSTMENTS_ALL

Line 2166: OZF_RESALE_ADJUSTMENTS_ALL oe

2162: ,util.reference_id
2163: FROM ozf_funds_utilized_all_b util,
2164: ozf_temp_eligibility temp,
2165: ozf_offer_adjustment_lines adjl,
2166: OZF_RESALE_ADJUSTMENTS_ALL oe
2167: WHERE util.plan_type = 'OFFR'
2168: AND product_id IS NOT NULL
2169: AND util.plan_id = p_qp_list_header_id
2170: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2290: OZF_RESALE_ADJUSTMENTS_ALL oe

2286: ,util.reference_id
2287: FROM ozf_funds_utilized_all_b util,
2288: ozf_temp_eligibility temp,
2289: ozf_offer_adjustment_lines adjl,
2290: OZF_RESALE_ADJUSTMENTS_ALL oe
2291: WHERE util.plan_type = 'OFFR'
2292: AND product_id IS NOT NULL
2293: AND util.plan_id = p_qp_list_header_id
2294: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2380: OZF_RESALE_ADJUSTMENTS_ALL oe

2376: ,util.reference_id
2377: FROM ozf_funds_utilized_all_b util,
2378: ozf_temp_eligibility temp,
2379: ozf_offer_adjustment_lines adjl,
2380: OZF_RESALE_ADJUSTMENTS_ALL oe
2381: WHERE util.plan_type = 'OFFR'
2382: AND product_id IS NOT NULL
2383: AND util.plan_id = p_qp_list_header_id
2384: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

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: