DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2498: oe_order_headers_all head

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'
2502: AND line.cancelled_flag = 'N'

Line 2529: oe_order_headers_all head

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'
2533: AND line.cancelled_flag = 'N'

Line 4156: oe_order_headers_all head

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'
4160: AND line.cancelled_flag = 'N'