DBA Data[Home] [Help]

APPS.OE_BATCH_PRICING dependencies on HZ_PARTIES

Line 89: hz_parties party,

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'
93: and h.order_number between nvl(p_order_number_low, h.order_number) and nvl(p_order_number_high, h.order_number)

Line 120: hz_parties party,

116: oe_order_lines l,
117: mtl_item_categories ic,
118: mtl_default_category_sets cs,
119: hz_cust_accounts cust,
120: hz_parties party,
121: oe_transaction_types_tl tt
122: where h.open_flag = 'Y'
123: and h.order_number between nvl(p_order_number_low, h.order_number) and nvl(p_order_number_high, h.order_number)
124: and h.order_type_id = nvl(p_order_type_id, h.order_type_id)