APPS.OE_BATCH_PRICING dependencies on OE_ORDER_HEADERS

Line 88: from oe_order_headers h,

84: /* Main cursor query to fetch the orders matching input criteria */
85: CURSOR C_ORDERS
86: IS
87: select h.org_id, h.header_id, 0 line_id, 0 line_number, 0 shipment_number, h.order_number, party.party_name account_name, tt.name order_type, h.transactional_curr_code
88: from oe_order_headers h,
89: hz_parties party,
90: hz_cust_accounts cust,
91: oe_transaction_types_tl tt
92: where h.open_flag = 'Y'

Line 115: from oe_order_headers h,

111: /* Main cursor query to fetch the lines matching input criteria */
112: CURSOR C_LINES
113: IS
114: select l.org_id, l.header_id, l.line_id, l.line_number, l.shipment_number, h.order_number, party.party_name account_name, tt.name order_type, h.transactional_curr_code
115: from oe_order_headers h,
116: oe_order_lines l,
117: mtl_item_categories ic,
118: mtl_default_category_sets cs,
119: hz_cust_accounts cust,