APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_ADJUSTMENTS_ALL

Line 1072: ozf_resale_adjustments_all ora

1068: p_inventory_item_id NUMBER) IS
1069: SELECT sum(orl.quantity) used_quantity,
1070: orl.uom_code
1071: FROM ozf_resale_lines_all orl,
1072: ozf_resale_adjustments_all ora
1073: WHERE orl.inventory_item_id = p_inventory_item_id
1074: AND NVL(ora.corrected_agreement_id, ora.agreement_id) = p_request_header_id
1075: AND orl.resale_line_id = ora.resale_line_id
1076: AND ora.agreement_type = 'SPO'