APPS.CSD_DEPOT_REPAIR_CNTR dependencies on HR_ORGANIZATION_UNITS

Line 159: **** Added hr_organization_units in from clause

155:
156: is
157: v_total_records number;
158: /**** Added Organization name in Select columns to fix bug 2760279
159: **** Added hr_organization_units in from clause
160: **** Added one joing with hr_organization_units ******************/
161:
162: Cursor RMA_RECEIPT_LINES( p_repair_line_id number ) is
163: SELECT /*+ CHOOSE */ oeh.order_number rma_number,

Line 160: **** Added one joing with hr_organization_units ******************/

156: is
157: v_total_records number;
158: /**** Added Organization name in Select columns to fix bug 2760279
159: **** Added hr_organization_units in from clause
160: **** Added one joing with hr_organization_units ******************/
161:
162: Cursor RMA_RECEIPT_LINES( p_repair_line_id number ) is
163: SELECT /*+ CHOOSE */ oeh.order_number rma_number,
164: oeh.header_id rma_header_id,

Line 182: hr_organization_units hou

178: hou.name organization_name
179: FROM rcv_transactions rcvt,
180: oe_order_headers_all oeh,
181: oe_order_lines_all oel,
182: hr_organization_units hou
183: WHERE oel.header_id = oeh.header_id
184: AND rcvt.oe_order_line_id = oel.line_id
185: AND rcvt.transaction_type = 'RECEIVE'
186: AND rcvt.source_document_code = 'RMA'