DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OE_ORDER_LINES_ALL

Line 2440: oe_order_lines_all line,

2436: line.order_quantity_uom,
2437: head.transactional_curr_code order_currency,
2438: NVL(line.actual_shipment_date, line.request_date) trans_date
2439: FROM oe_price_adjustments adj,
2440: oe_order_lines_all line,
2441: oe_order_headers_all head
2442: WHERE adj.list_header_id = l_offer_id
2443: AND adj.line_id = line.line_id
2444: AND line.open_flag = 'N'

Line 2471: oe_order_lines_all line,

2467: line.order_quantity_uom,
2468: head.transactional_curr_code order_currency,
2469: NVL(line.actual_shipment_date, line.request_date) trans_date
2470: FROM oe_price_adjustments adj,
2471: oe_order_lines_all line,
2472: oe_order_headers_all head
2473: WHERE adj.list_header_id = l_offer_id
2474: AND adj.line_id = line.line_id
2475: AND line.open_flag = 'N'

Line 4092: oe_order_lines_all line,

4088: line.order_quantity_uom,
4089: head.transactional_curr_code order_currency,
4090: NVL(line.actual_shipment_date,line.request_date) trans_date
4091: FROM oe_price_adjustments adj,
4092: oe_order_lines_all line,
4093: oe_order_headers_all head
4094: WHERE adj.list_header_id = l_offer_id
4095: AND adj.line_id = line.line_id
4096: AND line.open_flag = 'N'