DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OE_ORDER_LINES_ALL

Line 2497: oe_order_lines_all line,

2493: line.order_quantity_uom,
2494: head.transactional_curr_code order_currency,
2495: NVL(line.actual_shipment_date, line.request_date) trans_date
2496: FROM oe_price_adjustments adj,
2497: oe_order_lines_all line,
2498: oe_order_headers_all head
2499: WHERE adj.list_header_id = l_offer_id
2500: AND adj.line_id = line.line_id
2501: AND line.open_flag = 'N'

Line 2528: oe_order_lines_all line,

2524: line.order_quantity_uom,
2525: head.transactional_curr_code order_currency,
2526: NVL(line.actual_shipment_date, line.request_date) trans_date
2527: FROM oe_price_adjustments adj,
2528: oe_order_lines_all line,
2529: oe_order_headers_all head
2530: WHERE adj.list_header_id = l_offer_id
2531: AND adj.line_id = line.line_id
2532: AND line.open_flag = 'N'

Line 4155: oe_order_lines_all line,

4151: line.order_quantity_uom,
4152: head.transactional_curr_code order_currency,
4153: NVL(line.actual_shipment_date,line.request_date) trans_date
4154: FROM oe_price_adjustments adj,
4155: oe_order_lines_all line,
4156: oe_order_headers_all head
4157: WHERE adj.list_header_id = l_offer_id
4158: AND adj.line_id = line.line_id
4159: AND line.open_flag = 'N'