DBA Data[Home] [Help]

APPS.CSD_DEPOT_REPAIR_CNTR dependencies on OE_ORDER_LINES_ALL

Line 55: FROM oe_order_lines_all

51: BEGIN
52: SELECT
53: split_from_line_id
54: INTO l_line_id
55: FROM oe_order_lines_all
56: WHERE line_id = l_line_id
57: AND header_id = l_header_id;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN

Line 181: oe_order_lines_all oel,

177: rcvt.subinventory,
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'

Line 1153: oe_order_lines_all oel,

1149: wsh_new_deliveries dl,
1150: wsh_delivery_assignments da,
1151: wsh_delivery_details dd ,
1152: oe_order_headers_all oeh,
1153: oe_order_lines_all oel,
1154: csd_Repairs cra,
1155: cs_estimate_Details ced,
1156: mtl_units_of_measure mtlu
1157: Where ((cra.repair_line_id = ced.original_source_id