APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_RESALE_ADJUSTMENTS

Line 3931: ozf_resale_adjustments ora

3927: AND plan_id = b.list_header_id
3928: UNION ALL
3929: SELECT 1
3930: FROM ozf_funds_utilized_all_b ofuab,
3931: ozf_resale_adjustments ora
3932: WHERE ofuab.plan_id = b.list_header_id
3933: AND ora.list_header_id = b.list_header_id
3934: AND ofuab.utilization_type = 'ACCRUAL'
3935: AND ofuab.object_type = 'TP_ORDER');

Line 6088: OZF_RESALE_ADJUSTMENTS_ALL oe

6084: ,util.exchange_rate_type
6085: FROM ozf_funds_utilized_all_b util,
6086: ozf_temp_eligibility temp,
6087: ozf_offer_adjustment_lines adjl,
6088: OZF_RESALE_ADJUSTMENTS_ALL oe
6089: WHERE util.plan_type = 'OFFR'
6090: AND product_id IS NOT NULL
6091: AND util.plan_id = p_qp_list_header_id
6092: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6227: OZF_RESALE_ADJUSTMENTS_ALL oe

6223: ,util.exchange_rate_type
6224: FROM ozf_funds_utilized_all_b util,
6225: ozf_temp_eligibility temp,
6226: ozf_offer_adjustment_lines adjl,
6227: OZF_RESALE_ADJUSTMENTS_ALL oe
6228: WHERE util.plan_type = 'OFFR'
6229: AND product_id IS NOT NULL
6230: AND util.plan_id = p_qp_list_header_id
6231: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6332: OZF_RESALE_ADJUSTMENTS_ALL oe

6328: ,util.exchange_rate_type
6329: FROM ozf_funds_utilized_all_b util,
6330: ozf_temp_eligibility temp,
6331: ozf_offer_adjustment_lines adjl,
6332: OZF_RESALE_ADJUSTMENTS_ALL oe
6333: WHERE util.plan_type = 'OFFR'
6334: AND product_id IS NOT NULL
6335: AND util.plan_id = p_qp_list_header_id
6336: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

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: